polars query for dataframe

Query dataframe using SQL. Note: The dataframe is always named 'df' in your query's from clause.

Signature

> polars query {flags} (sql)

Parameters

  • sql: sql query

Input/output types:

inputoutput
anyany

Examples

Query dataframe using SQL

> [[a b]; [1 2] [3 4]] | polars into-df | polars query 'select a from df'
╭───┬───╮
 # │ a │
├───┼───┤
 0 1
 1 3
╰───┴───╯