Implement `WITH` for create index

kysely-org / kysely

A type-safe typescript SQL query builder

https://kysely.dev

MIT License

10.44k stars 267 forks source link

Implement `WITH` for create index #1017

Open FuJa0815 opened 4 months ago

FuJa0815 commented 4 months ago

Postgresql and mssql support WITH clauses for CREATE INDEX calls. It would be great for kysely to support these in some way, or at least expose a modifyEnd method for createIndex.

https://www.postgresql.org/docs/current/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAMETERS https://learn.microsoft.com/en-us/sql/t-sql/statements/create-index-transact-sql?view=sql-server-ver16#relational_index_option

igalklebanov commented 4 months ago

Hey 👋

It's a niche feature, so I'm leaning towards adding modifyEnd.