Instance methods inherited from module Focus::SQLite::Statements::Dsl::SetOperators

except(rhs : Focus::SelectStatement) : Focus::SetStatement except, except_all(rhs : Focus::SelectStatement) : Focus::SetStatement except_all, intersect(rhs : Focus::SelectStatement) : Focus::SetStatement intersect, intersect_all(rhs : Focus::SelectStatement) : Focus::SetStatement intersect_all, union(rhs : Focus::SelectStatement) : Focus::SetStatement union, union_all(rhs : Focus::SelectStatement) : Focus::SetStatement union_all

Instance methods inherited from module Focus::SQLite::Statement

dialect : Focus::Dialect dialect

Instance methods inherited from class Focus::SelectStatement

aliased(label : String) : Focus::SelectTable aliased, as_cte(label : String) : Focus::CommonTableExpression as_cte, distinct : self distinct, from(table : Focus::ReadableTable) : self from, from_clause : Focus::FromClause | Nil from_clause, from_clause=(from_clause : Focus::FromClause | Nil) from_clause=, group_by(*columns : Focus::Column) : self group_by, group_by_clause : Focus::GroupByClause | Nil group_by_clause, group_by_clause=(group_by_clause : Focus::GroupByClause | Nil) group_by_clause=, having(expression : Focus::BoolExpression) : self having, having_clause : Focus::HavingClause | Nil having_clause, having_clause=(having_clause : Focus::HavingClause | Nil) having_clause=, limit(limit : Int32) : self limit, limit_clause : Focus::LimitClause | Nil limit_clause, limit_clause=(limit_clause : Focus::LimitClause | Nil) limit_clause=, offset(offset : Int32) : self offset, offset_clause : Focus::OffsetClause | Nil offset_clause, offset_clause=(offset_clause : Focus::OffsetClause | Nil) offset_clause=, order_by(*clauses : Focus::OrderByClause) : self order_by, order_by_clauses : Focus::OrderByListClause | Nil order_by_clauses, order_by_clauses=(order_by_clauses : Focus::OrderByListClause | Nil) order_by_clauses=, ordered_clauses : Array(Focus::Clause) ordered_clauses, select_clause : Focus::SelectClause select_clause, statement_type : Focus::SqlFormatter::StatementType statement_type, where(expression : Focus::BoolExpression) : self where, where_clause : Focus::WhereClause | Nil where_clause, where_clause=(where_clause : Focus::WhereClause | Nil) where_clause=

Constructor methods inherited from class Focus::SelectStatement

new(select_clause : Focus::SelectClause) new

Instance methods inherited from class Focus::Statement

accept(visitor : Focus::SqlVisitor) : Nil accept, dialect : Focus::Dialect dialect, ordered_clauses : Array(Focus::Clause) ordered_clauses, statement_type : Focus::SqlFormatter::StatementType statement_type, to_sql to_sql, to_sql_with_args : Tuple(String, Array(DB::Any)) to_sql_with_args

Instance methods inherited from module Focus::Queryable

exec(database : Focus::DBConn) : DB::ExecResult exec, query(database : Focus::DBConn) : DB::ResultSet query, query_all(database : Focus::DBConn, as types : Tuple)
query_all(database : Focus::DBConn, as types : NamedTuple)
query_all(database : Focus::DBConn, as types : Class) query_all, query_one(database : Focus::DBConn, as types : Tuple)
query_one(database : Focus::DBConn, as type : NamedTuple)
query_one(database : Focus::DBConn, as : T.class) : T forall T query_one, query_one?(database : Focus::DBConn, as type : Tuple)
query_one?(database : Focus::DBConn, as type : NamedTuple)
query_one?(database : Focus::DBConn, as : T.class) : T | Nil forall T query_one?, to_sql_with_args : Tuple(String, Array(DB::Any)) to_sql_with_args