You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently, Drizzle ORM supports common table expression (CTE) / WITH queries for the Postgres dialect. It would be useful for Drizzle to allow users to configure materialization options for when the query is executed.
Describe what you want
Currently, Drizzle ORM supports common table expression (CTE) / WITH queries for the Postgres dialect. It would be useful for Drizzle to allow users to configure materialization options for when the query is executed.
Currently, CTEs can be used with something like:
The above will generate SQL like the following:
Supporting a new configuration parameter on the
.with()
method might allow passing materialization options. For example:Specifying the materialization mode as shown above would presumably generate some SQL like:
The following materialization modes would ideally be supported:
CteMaterializationMode.DEFAULT
(current serialization behavior)CteMaterializationMode.MATERIALIZED
CteMaterializationMode.NOT_MATERIALIZED
The text was updated successfully, but these errors were encountered: