Skip to main content

Client API

All LakeBase clients implement the SqlClient interface.

MethodDescription
connect(dsn=None, **kwargs) → selfEstablish connection, returns self for chaining
execute(sql, params)Run a statement, return rowcount
fetchall(sql, params)Run a query, return list[tuple]
fetchone(sql, params)Run a query, return first row or None
cursor()Raw cursor for advanced use
raw_connectionUnderlying psycopg2 connection
close()Close the connection
__enter__ / __exit__Context manager — closes on exit