lamindb.dev.db.SelectStmt#

class lamindb.dev.db.SelectStmt(*tables, stmt=None, session=None)#

Bases: ExecStmt

Executable select statement.

Offers an exact subset of SQLAlchemy of constraining select with where, join, order_by, offset, limit.

Offers accessing the results of the executed statement via all, df, one, one_or_none through the base class ExecStmt.

Methods

join(*expression, **fields)#

Pass a target table as an expression.

limit(n)#

Pass an integer.

offset(n)#

Pass an integer.

order_by(expression)#

Pass a field.

where(*conditions)#

Pass one or multiple conditions.

If multiple conditions are passed, they are combined using AND.

If OR is desired, use sqlmodel.or_.