SQL statements

Each command page includes examples, supported syntax, and usage notes.

Queries

• SELECT - filter, join, aggregate, and sort rows.
• VALUES - construct rows from expressions.
• EXPLAIN - inspect a query’s physical plan.

Writing data

• INSERT - append values or query results.
• COPY - stream Arrow IPC rows from a client.

Schemas and tables

• CREATE TABLE - define columns, configure layout, or adopt Parquet files.
• CREATE SCHEMA - create a namespace for tables.
• DROP TABLE - remove a table from the catalog.

Maintenance

• COMPACT - merge and re-sort Parquet files.

Users and sessions

• CREATE USER - add a login user.
• SET / RESET - control query statistics for a connection.
• Transaction behavior - understand the behavior of BEGIN, COMMIT, and ROLLBACK.

Compatibility

PostgreSQL wire compatibility lets PostgreSQL clients connect. It does not imply support for every PostgreSQL statement or statement variant.

DELETE is not supported yet. Planned additions are tracked in the roadmap.