class Sqlite3::QueryBuilder

• Sqlite3::QueryBuilder
• QueryBuilder::SqlBuilder(Bool | Float32 | Float64 | Int32 | Int64 | Slice(UInt8) | String | Time | Nil)
• Reference
• Object

Defined in:

sqlite3/query_builder.cr

Instance Method Summary

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

  Delete

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

  Insert specifics

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

  Update specifics

• #update(table : From)
• #values(ivalues : Array(DB::Any))
• #values(*ivalues)
• #where(criteria : Criteria)
• #where(**conditions)

Instance Method Detail