PostgreSQL No support for CREATE INDEX CONCURRENTLY

[shockie]

SQLDelight Version

2.0.0

SQLDelight Dialect

PostgreSQL

Describe the Bug

Creating an index via CREATE INDEX CONCURRENTLY fails, even when I try to add the index via CREATE INDEX the migration fails.

It feels related with #4501 since it's a CREATE statement.

Stacktrace

No response

[griffio]

🍔 The create_index_stmt would have to be added - something like below - in PostgreSql.bnf

🔎

create_index_stmt ::= CREATE [ UNIQUE ] INDEX [ 'CONCURRENTLY' ] [ IF NOT EXISTS ] [ {database_name} DOT ] {index_name} ON {table_name} LP {indexed_column} ( COMMA {indexed_column} ) * RP [ WHERE <<expr '-1'>> ] {
  extends = "com.alecstrong.sql.psi.core.psi.impl.SqlCreateIndexStmtImpl"
  override = true
  pin = 6
}