Statement Index
The seaquell DSL provides over 500 functions for building SQL statements.
This document helps you know which ones to use for each kind of statement.
It is organized alphabetically by statement and provides the following information:
-
Links to SQLite documentation with helpful syntax diagrams
-
Links to relevant tests
-
Functions used to create the statement
-
Functions used to define clauses or properties of the statement
Begin Transaction
-
SQLite reference
-
Functions:
begin,begin-deferred,begin-deferred-transaction,begin-exclusive,begin-exclusive-transaction,begin-immediate,begin-immediate-transaction,begin-transaction -
See also Commit Transaction, End Transaction, Rollback
Commit Transaction
-
SQLite reference
-
Functions:
commit,commit-transaction,end,end-transaction -
See also Begin Transaction, End Transaction, Rollback
Create Index
-
SQLite reference (create index, partial indexes, indexes on expressions)
-
Functions:
create,create-index,create-if-not-exists,create-index-if-not-exists,create-unique-index,create-unique-index-if-not-exists -
Properties:
index,if-not-exists,unique,on,columns,collate,asc,desc,where
Create Table
-
SQLite reference (create table, foreign keys, generated columns, WITHOUT ROWID)
-
Tests (create, constraints)
-
Functions:
create,create-table,create-if-not-exists,create-table-if-not-exists,create-temp,create-temp-table,create-temporary,create-temporary-tablecreate-temp-if-not-exists,create-temp-table-if-not-exists,create-temporary-if-not-exists,create-temporary-table-if-not-exists -
Properties:
columns,column,ctype,as,without-rowid -
Column constraints:
constraints,constraint,check,collate,default,primary-key,asc,desc,order,autoincrement,unique,not-null,on-conflict,generated,generated-as,generated-always,generated-always-as,always,as,stored,virtual,references -
Table constraints:
constraints,constraint,primary-key,unique,columns,column,collate,asc,desc,order,check,foreign-key,references -
See also Select
Conflict Clause
-
Functions:
on-conflict,on-conflict-abort,on-conflict-fail,on-conflict-ignore,on-conflict-replace,on-conflict-rollback
Foreign Key Clause
-
Functions:
references -
Properties:
table,columns,column,match -
On Delete/Update Actions:
on-delete,on-delete-cascade,on-delete-no-action,on-delete-restrict,on-delete-set-default,on-delete-set-null,on-update,on-update-cascade,on-update-no-action,on-update-restrict,on-update-set-default,on-update-set-null, -
Deferred:
deferrable,not-deferrable,initially,modifier,deferrable-initially-deferred,deferrable-initially-immediate,not-deferrable-initially-deferred,not-deferrable-initially-immediate,
Create Trigger
-
SQLite reference
-
Functions:
create,create-trigger,create-if-not-exists,create-trigger-if-not-exists,create-temp,create-temp-trigger,create-temporary,create-temporary-triggercreate-temp-if-not-exists,create-temp-trigger-if-not-exists,create-temporary-if-not-exists,create-temporary-trigger-if-not-exists -
Properties:
trigger,temp,temporary,if-not-exists,after,after-delete,after-insert,after-update-of,before,before-delete,before-insert,before-update-of,instead-of,instead-of-delete,instead-of-insert,instead-of-update-offire,delete,insert,update-of,op,on,for-each-row,when,begin
Create View
-
SQLite reference
-
Functions:
create,create-view,create-if-not-exists,create-view-if-not-exists,create-temp,create-temp-view,create-temporary,create-temporary-viewcreate-temp-if-not-exists,create-temp-view-if-not-exists,create-temporary-if-not-exists,create-temporary-view-if-not-exists -
Properties:
view,temp,temporary,if-not-exists,columns,column,as -
See also Select
End Transaction
-
SQLite reference
-
Functions:
end,end-transaction,commit,commit-transaction -
See also Begin Transaction, Commit Transaction, Rollback
Insert
-
SQLite reference (insert, upsert clause, with clause)
-
Functions:
insert,insert-into,replace-into,insert-or-replace,insert-or-rollback,insert-or-abort,insert-or-fail,insert-or-ignore -
Properties:
with,with-recursive,columns,defaults,default-values,do-nothing,do-update,on-conflict,on-conflict-do-nothing,set,value,values,where
Rollback
-
SQLite reference (transaction, savepoint)
-
Functions:
rollback,rollback-transaction,rollback-to,rollback-to-savepoint,rollback-transaction-to,rollback-transaction-to-savepoint -
Properties:
to,to-savepoint -
See also Begin Transaction, Commit Transaction, Savepoint
Select
-
SQLite reference (select, window functions, with clause)
-
Tests (Select, Compound Select, Values)
-
Examples (SQLZoo, Pieces and Providers)
-
Functions:
select,select-all,select-distinct,select-from,value,values -
Modifiers:
modifier,all,distinct -
Compound:
compound-select,intersect,intersect-all,except,except-all,union,union-all -
Clauses:
with,with-recursive,from,where,group-by,having,window,order-by,limit,offset -
Order Term:
order-term,order,asc,collate,desc,nulls,nulls-first,nulls-last -
Joins:
on,using,src,op,comma-join,nil-join,straight-join,cross-join,inner-join,left-join,right-join,full-join,left-outer-join,right-outer-join,full-outer-join,natural-join,natural-cross-join,natural-inner-join,natural-left-join,natural-right-join,natural-full-join,natural-left-outer-join,natural-right-outer-join,natural-full-outer-join -
Window functions:
window,as,partition-by,order-by,frame,bounds,lo-bound,hi-bound,unbounded,unbounded-following,unbounded-preceding,following,preceding,current-row,exclude,exclude-current-row,exclude-group,exclude-no-others,exclude-ties,
Update
-
SQLite reference (update, with clause)
-
Functions:
update,update-or-replace,update-or-rollback,update-or-abort,update-or-fail,update-or-ignore -
Properties:
as,with,with-recursive,columns,indexed-by,not-indexed,set,where
Can you improve this documentation?Edit on GitHub
cljdoc is a website building & hosting documentation for Clojure/Script libraries
× close