📄️ Overview
Goose's SQL dialect is based on PostgreSQL.
📄️ Friendly SQL
Goose offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”.
📄️ Indexing
Goose uses 1-based indexing except for JSON objects, which use 0-based indexing.
📄️ Keywords and Identifiers
Identifiers
📄️ Order Preservation
For many operations, Goose preserves the order of rows, similarly to data frame libraries such as Pandas.
📄️ PostgreSQL Compatibility
Goose's SQL dialect closely follows the conventions of the PostgreSQL dialect.
📄️ SQL Quirks
Like all programming languages and libraries, Goose has its share of idiosyncrasies and inconsistencies.