Skip to content

SQL statements

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

  • SELECT - filter, join, aggregate, and sort rows.
  • VALUES - construct rows from expressions.
  • EXPLAIN - inspect a query’s physical plan.
  • INSERT - append values or query results.
  • COPY - stream Arrow IPC rows from a client.
  • COMPACT - merge and re-sort Parquet files.

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.