struct

Luna::QueryBuilder::Select

Inherits Struct < Value < Object

SELECT builder

Constructors

new(table : String, columns : Array(String) = ["*"] of String)
Source

Instance methods

add_join(type : Symbol, table : String, on : String, table_alias : String | Nil = nil, params : Array(DB::Any) = [] of DB::Any)
Source
bound_params
Source
inner_join(table : String, on : String, table_alias : String | Nil = nil)
Source
inner_join(table : String, on : String, *params : DB::Any, table_alias : String | Nil = nil)
Source
left_join(table : String, on : String, table_alias : String | Nil = nil)
Source
left_join(table : String, on : String, *params : DB::Any, table_alias : String | Nil = nil)
Source
limit(n : Int32)
Source
offset(n : Int32)
Source
order(*cols : String)
Source
select(*cols : String)
Source
to_sql
Source
where(cond : String, *vals : DB::Any)
Source
where_array(cond : String, vals : Array(DB::Any) | NamedTuple)
Source
where_hash(filters : Hash(Symbol, DB::Any))
Source
where_hash(filters : NamedTuple)

NamedTuple variant

Source
where_in(column : String, vals : Array(DB::Any))
Source