SQL Interface

This page gives an overview of all public SQL functions and operations supported by Polars.

Python API

• Python API
  • Introduction
    • Global SQL
    • Frame SQL
    • Expression SQL
    • SQLContext

Query Clauses

• Query Clauses
  • SELECT
  • DISTINCT
  • DISTINCT ON
  • FROM
  • JOIN
  • WHERE
  • GROUP BY
  • GROUP BY ALL
  • HAVING
  • WINDOW
  • QUALIFY
  • ORDER BY
  • ORDER BY ALL
  • OFFSET
  • LIMIT
  • FETCH

Set Operations

• Set Operations
  • EXCEPT
  • EXCEPT BY NAME
  • INTERSECT
  • INTERSECT BY NAME
  • UNION
  • UNION ALL
  • UNION BY NAME

Table Operations

• Table Operations
  • ALTER TABLE
  • CREATE SCHEMA
  • CREATE TABLE
  • DELETE
  • DROP SCHEMA
  • DROP TABLES
  • EXPLAIN
  • INSERT
  • SHOW TABLES
  • GENERATE_SERIES
  • RANGE
  • UNNEST
  • TRUNCATE

Functions

Overview

• Functions
  • Aggregate
  • Array
  • Bitwise
  • Conditional
  • Math
  • String
  • Temporal
  • Trigonometry
  • Types
  • Window

Operators

• Operators
  • Logical
  • Comparison
  • Numeric
  • Bitwise
  • String
  • Regex
  • Indexing