Polars Concepts¶

Polars SQL¶

Polars SQL supports a SQL dialect for querying and managing data. This documentation lists the statements, functions, and types that are available in Polars SQL.

Compatibility¶

Some SQL syntax and functions are supported, while unsupported features are omitted from the main reference pages and recorded in Polars SQL Differences.

Equivalent Syntax¶

Polars SQL also supports some equivalent syntax with different names or argument order. These differences are recorded in Polars SQL Differences.

Tables and Schemas¶

SQL examples in this documentation use Polars SQL table spaces, schemas, and tables that can be created by the SQL logic test runner. Catalog and connector administration concepts are not documented as Polars SQL features unless they are available in Polars SQL.

Statements and Queries¶

A statement is SQL text submitted to Polars. A query is a statement that returns rows. Supported SQL statements are listed under SQL Statement Syntax; supported types and functions are listed under SQL Language and Functions and Operators.