class

Sqlite3::QueryBuilder

Inherits QueryBuilder::SqlBuilder < Reference < Object

Instance methods

build
Source
columns(insert_columns : Array(String | Projection))
Source
columns(*insert_columns)
Source
delete(table : String)

Delete

Source
delete(table : From)
Source
distinct
Source
from(table : String)
Source
from(subquery : SqlBuilder)
Source
from(from : From)
Source
from_select(subquery : SqlBuilder)
Source
group_by(*columns)
Source
having(criteria : Criteria)
Source
inner_join(table : String, condition : String)
Source
insert

Insert specifics

Source
into(table : String, aliased_name : String | Nil = nil)
Source
into(table : From)
Source
join(table : String, condition : String)
Source
left_join(table : String, condition : String)
Source
limit(rows : Int32, offset : DB::Any | Nil = nil)
Source
not_distinct
Source
or(criteria : Criteria)
Source
or
Source
order_by(*columns, sort : String = "ASC", ignore_case : Bool = false)
Source
params
Source
reset!
Source
reset_group_by!
Source
reset_limit!
Source
reset_order_by!
Source
select(columns : Array(String | Projection))
Source
select(*columns)
Source
set(column : String, value : T | T | T | T | T | T(UInt8) | T | T | T)
Source
set(column : Projection, value : T | T | T | T | T | T(UInt8) | T | T | T)
Source
union(query : SqlBuilder)
Source
union_all(query : SqlBuilder)
Source
update(table : String)

Update specifics

Source
update(table : From)
Source
values(ivalues : Array(DB::Any))
Source
values(*ivalues)
Source
where(criteria : Criteria)
Source
where
Source