title: 'Prepared Statements'
sidebar_label: 'Prepared Statements'
pagination_prev: 'reference/sql/subqueries'
pagination_next: 'reference/sql/explain'
sidebar_position: 4
Positional Arguments
Prepared statements can use positional arguments to support multiple parameters. Each parameter is referenced by its position in the statement.
SQL Example
To create a prepared statement named greater_than with two parameters:
PREPARE greater_than(INT, DOUBLE) AS SELECT * FROM example WHERE a > $1 AND b > $2;
PREPARE greater_than(INT, DOUBLE) AS SELECT * FROM example WHERE a > $1 AND b > $2;
To execute the prepared statement with integer and double arguments:
EXECUTE greater_than(20, 23.3);
EXECUTE greater_than(20, 23.3);
Python Example
import adbc_driver_flightsql.dbapi
with adbc_driver_flightsql.dbapi.connect("grpc://localhost:50051") as conn:
with conn.cursor() as cur:
cur.execute("PREPARE greater_than(INT, DOUBLE) AS SELECT * FROM example WHERE a > $1 AND b > $2;")
cur.execute("EXECUTE greater_than(?, ?)", (20, 23.3))
result = cur.fetchall()
print(result)
import adbc_driver_flightsql.dbapi
with adbc_driver_flightsql.dbapi.connect("grpc://localhost:50051") as conn:
with conn.cursor() as cur:
cur.execute("PREPARE greater_than(INT, DOUBLE) AS SELECT * FROM example WHERE a > $1 AND b > $2;")
cur.execute("EXECUTE greater_than(?, ?)", (20, 23.3))
result = cur.fetchall()
print(result)
:::warning[Limitations]
- Positional arguments are not supported with the
date keyword to construct a date value, like date $1. Specify the date value in the query instead: l_shipdate > date '1995-01-01'.
:::
