BigQuery support - Githubissues

nene / prettier-plugin-sql-cst

Prettier SQL plugin that uses sql-parser-cst

https://nene.github.io/prettier-sql-playground/

GNU General Public License v3.0

123 stars 7 forks source link

BigQuery support #2

Closed nene closed 1 year ago

nene commented 1 year ago

DML Statements

[x] SELECT
[x] INSERT
[x] DELETE
[x] UPDATE
[x] TRUNCATE TABLE
[x] MERGE

DDL Statements

[x] CREATE TABLE
[x] CREATE VIEW
[x] CREATE SCHEMA
[x] CREATE FUNCTION
[x] CREATE PROCEDURE
[x] CREATE ROW ACCESS POLICY
[x] CREATE CAPACITY
[x] CREATE RESERVATION
[x] CREATE ASSIGNMENT
[x] CREATE SEARCH INDEX
[x] ALTER SCHEMA
[x] ALTER TABLE
[x] ALTER VIEW
[x] ALTER ORGANIZATION
[x] ALTER PROJECT
[x] ALTER BI_CAPACITY
[x] ALTER CAPACITY
[x] ALTER RESERVATION
[x] DROP TABLE
[x] DROP VIEW
[x] DROP SCHEMA
[x] DROP FUNCTION
[x] DROP PROCEDURE
[x] DROP ROW ACCESS POLICY
[x] DROP CAPACITY
[x] DROP RESERVATION
[x] DROP ASSIGNMENT
[x] DROP SEARCH INDEX

Other Statements

[x] GRANT
[x] REVOKE
[x] ASSERT
[x] EXPORT DATA
[x] LOAD DATA

Prepared statements

[x] EXECUTE IMMEDIATE

Procedural language

[x] DECLARE
[x] SET
[x] BEGIN .. END block
[x] BEGIN .. EXCEPTION .. END block
[x] procedural CASE
[x] IF .. THEN .. ELSEIF .. ELSE .. END IF
[x] block labels
[x] LOOP .. END LOOP
[x] REPEAT .. UNTIL .. END REPEAT
[x] WHILE cond DO .. END WHILE
[x] BREAK / LEAVE
[x] CONTINUE / ITERATE
[x] FOR var IN expr DO .. END FOR
[x] RAISE
[x] RETURN
[x] CALL

Transactions

[x] BEGIN [TRANSACTION]
[x] COMMIT [TRANSACTION]
[x] ROLLBACK [TRANSACTION]