SQL Interface

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

Python API

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

SQL Clauses

• SQL Clauses
  • SELECT
  • DISTINCT
  • FROM
  • JOIN
  • WHERE
  • GROUP BY
  • HAVING
  • ORDER BY
  • LIMIT
  • OFFSET

SQL Functions

Overview

• SQL Functions
  • Aggregate
  • Array
  • Conditional
  • Math
  • String
  • Temporal
  • Trigonometry
  • Types

Set Operations

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

Table Operations

• Table Operations
  • CREATE TABLE
  • DROP TABLES
  • EXPLAIN
  • SHOW TABLES
  • UNNEST
  • TRUNCATE