Statements

Data definition language

Statement	Support	Notes
`CREATE TABLE`	Supported	Column-definition and `AS SELECT` forms. `CREATE OR REPLACE` is supported. Requires either a column list or an `AS SELECT`.
`CREATE VIEW`	Supported	`AS SELECT` form.
`CREATE SCHEMA`	Supported	`IF NOT EXISTS` supported. `AUTHORIZATION` is not supported; `OPTIONS(...)` and `DEFAULT COLLATE` are ignored.
`DROP TABLE`, `DROP VIEW`, `DROP SCHEMA`	Supported	`IF EXISTS`, `CASCADE`/`RESTRICT`, and multiple objects in one statement.
`CREATE VECTOR INDEX`	With limitations	Requires a `dimension` option (Firebolt needs an explicit vector dimension that BigQuery infers).
`ALTER TABLE`	With limitations	One operation per statement. Dropping several columns in one statement is not supported.
`CREATE MATERIALIZED VIEW`, `DROP MATERIALIZED VIEW`	Not supported
`CREATE EXTERNAL TABLE`	Not supported
`CREATE TABLE LIKE`, `CREATE TABLE COPY`, `CREATE TABLE CLONE`, `CREATE SNAPSHOT TABLE`	Not supported
`CREATE FUNCTION`, `CREATE TABLE FUNCTION`, `CREATE PROCEDURE`, `DROP FUNCTION`	Not supported
`CREATE ROW ACCESS POLICY`, `CREATE SEARCH INDEX`	Not supported
`ALTER SCHEMA`, `ALTER VIEW`, `ALTER MATERIALIZED VIEW`, `ALTER ORGANIZATION`	Not supported

Statement	Support	Notes
`INSERT`	Supported	`INSERT ... VALUES` and `INSERT ... SELECT`. The target must be a plain table name.
`UPDATE`	Supported	With a `WHERE` clause.
`DELETE`	Supported	With a `WHERE` clause.
`TRUNCATE TABLE`	Supported	Removes all rows (executed as an unconditional delete). Multiple targets in one statement are supported.
`MERGE`	Not supported

Column types in a CREATE TABLE ... AS SELECT column list are read as names only and do not re-type the selected columns.
INSERT, UPDATE, and DELETE do not support a RETURNING clause.
Procedural statements (CALL, EXECUTE IMMEDIATE, scripting) and data control statements (GRANT, REVOKE) are not supported in this mode. Use native Firebolt SQL for access control.