SELECT

To execute SELECT queries, Seafowl uses Apache DataFusion. It supports a subset of the PostgreSQL dialect, including:

• WITH (common table expressions, or CTEs)
• SELECT/FROM with joins
• Filters with WHERE and HAVING
• Sorting with ORDER BY
• Aggregations with GROUP BY
• Windows with PARTITION BY / ORDER BY (but not FILTER BY)

For a full reference on the supported SELECT clauses, see these resources:

• DataFusion SQL support status
• DataFusion SELECT syntax reference
• PostgreSQL SELECT syntax reference

In addition, Seafowl supports a custom time-travel query syntax, allowing for querying historical table data.