📄️ AsOf Join
What is an AsOf Join?
📄️ Full-Text Search
Goose supports full-text search via the fts extension.
📄️ Graph Queries
Goose supports graph queries via the DuckPGQ community extension, which implements the SQL/PGQ syntax from the SQL:2023 standard.
📄️ Merge Statement for SCD Type 2
This is a practical, step-by-step guide to using Goose’s MERGE statement (introduced in v1.4.0) to perform upserts and build Slowly Changing Dimension Type 2 (SCD Type 2) tables. Type 2 SCDs let you keep full historical versions of records while clearly identifying the current version, perfect for audit trails, data warehousing, and analytical workloads. Type 2 SCDs are practical when you want to know previous values of your primary key data, when it changed and for how long it was in a particular state.
📄️ query and query_table Functions
The querytable
📄️ Timestamp Issues
Timestamp with Time Zone Promotion Casts