Add support for CREATE TABLE PARTITION OF

[hypnoglow]

According to docs, currently only PARTITION BY is supported but PARTITION OF is not.

i.e. for the provided example

CREATE TABLE measurements (
  id int8 PRIMARY KEY,
  value float8 NOT NULL,
  date timestamptz NOT NULL,
  hot boolean
) PARTITION BY LIST (hot);

CREATE TABLE measurements_hot PARTITION OF measurements
FOR VALUES IN (TRUE);

You can write bun query for the first statement:

_, err := db.NewCreateTable().
	Model((*Measure)(nil)).
	PartitionBy("LIST (hot)").
	Exec(ctx)

But you cannot write a query for the second statement in the same manner.

Although it is possible to use db.Exec(...) with plain SQL, we would be happy to see support for PARTITION OF in ORM CreateTable query.

[Jeongseup]

I totally agree with you

[github-actions]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.

[hypnoglow]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.

Still relevant

[takaaa220]

I am considering trying to implement the PARTITION OF feature in Bun.
However, since this functionality is specific to PostgreSQL, I am uncertain whether Bun should support it.

What are the maintainers' thoughts on this matter?
@vmihailenco @j2gg0s

[j2gg0s]

However, since this functionality is specific to PostgreSQL, I am uncertain whether Bun should support it.

query_create_table.go#L116
PartitionOf is not supported by all drivers, such as SQLite,
so we might consider providing this functionality ourselves, with the caller controlling when to use it