sqlo
User Guide
Getting Started
Security Guide
Query Types
SELECT Queries
INSERT Queries
UPDATE Queries
DELETE Queries
Advanced Topics
Condition Objects
Expressions & Functions
JOIN Operations
Window Functions
Common Table Expressions (CTE)
JSON Support
Batch Operations
Integration & Recipes
Integration with aiomysql
Recipes and Best Practices
Troubleshooting
Reference
API Reference
sqlo
Index
Index
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
L
|
M
|
N
|
O
|
P
|
Q
|
R
|
S
|
U
|
V
|
W
A
alias (sqlo.expressions.Expression attribute)
allow_all_rows() (sqlo.query.delete.DeleteQuery method)
(sqlo.query.update.UpdateQuery method)
and_() (sqlo.Condition static method)
(sqlo.expressions.Condition static method)
and_order_by() (sqlo.Window method)
and_partition_by() (sqlo.Window method)
as_() (sqlo.expressions.Expression method)
(sqlo.query.select.SelectQuery method)
avg() (sqlo.expressions.FunctionFactory static method)
B
batch_update() (sqlo.query.update.UpdateQuery method)
build() (sqlo.Condition method)
(sqlo.expressions.ComplexCondition method)
(sqlo.expressions.Condition method)
(sqlo.query.delete.DeleteQuery method)
(sqlo.query.insert.InsertQuery method)
(sqlo.query.select.SelectQuery method)
(sqlo.query.update.UpdateQuery method)
(sqlo.Window method)
C
ComplexCondition (class in sqlo.expressions)
Condition (class in sqlo)
(class in sqlo.expressions)
count() (sqlo.expressions.FunctionFactory static method)
cross_join() (sqlo.query.select.SelectQuery method)
D
delete_from() (sqlo.Q static method)
DeleteQuery (class in sqlo.query.delete)
distinct() (sqlo.query.select.SelectQuery method)
E
exists() (sqlo.Condition static method)
(sqlo.expressions.Condition static method)
explain() (sqlo.query.select.SelectQuery method)
Expression (class in sqlo.expressions)
extract() (sqlo.expressions.JSON method)
(sqlo.JSON method)
F
force_index() (sqlo.query.select.SelectQuery method)
from_() (sqlo.query.select.SelectQuery method)
from_select() (sqlo.query.insert.InsertQuery method)
Func (class in sqlo)
(class in sqlo.expressions)
FunctionFactory (class in sqlo.expressions)
G
get_dialect() (sqlo.Q class method)
group_by() (sqlo.query.select.SelectQuery method)
H
having() (sqlo.query.select.SelectQuery method)
I
ignore() (sqlo.query.insert.InsertQuery method)
ignore_index() (sqlo.query.select.SelectQuery method)
in_() (sqlo.Condition static method)
(sqlo.expressions.Condition static method)
inner_join() (sqlo.query.select.SelectQuery method)
insert_into() (sqlo.Q static method)
InsertQuery (class in sqlo.query.insert)
J
join() (sqlo.query.delete.DeleteQuery method)
(sqlo.query.select.SelectQuery method)
(sqlo.query.update.UpdateQuery method)
JSON (class in sqlo)
(class in sqlo.expressions)
JSONPath (class in sqlo)
(class in sqlo.expressions)
L
left_join() (sqlo.query.delete.DeleteQuery method)
(sqlo.query.select.SelectQuery method)
(sqlo.query.update.UpdateQuery method)
limit() (sqlo.query.delete.DeleteQuery method)
(sqlo.query.select.SelectQuery method)
(sqlo.query.update.UpdateQuery method)
M
max() (sqlo.expressions.FunctionFactory static method)
min() (sqlo.expressions.FunctionFactory static method)
module
sqlo
sqlo.expressions
sqlo.query.delete
sqlo.query.insert
sqlo.query.select
sqlo.query.update
N
not_exists() (sqlo.Condition static method)
(sqlo.expressions.Condition static method)
not_in() (sqlo.Condition static method)
(sqlo.expressions.Condition static method)
not_null() (sqlo.Condition static method)
(sqlo.expressions.Condition static method)
null() (sqlo.Condition static method)
(sqlo.expressions.Condition static method)
O
offset() (sqlo.query.select.SelectQuery method)
on_duplicate_key_update() (sqlo.query.insert.InsertQuery method)
optimizer_hint() (sqlo.query.select.SelectQuery method)
or_() (sqlo.Condition static method)
(sqlo.expressions.Condition static method)
or_where() (sqlo.query.select.SelectQuery method)
order_by() (sqlo.query.delete.DeleteQuery method)
(sqlo.query.select.SelectQuery method)
(sqlo.query.update.UpdateQuery method)
(sqlo.Window class method)
over() (sqlo.expressions.Func method)
(sqlo.Func method)
P
paginate() (sqlo.query.select.SelectQuery method)
partition_by() (sqlo.Window class method)
Q
Q (class in sqlo)
R
range_between() (sqlo.Window method)
Raw (class in sqlo)
(class in sqlo.expressions)
raw() (sqlo.Q static method)
right_join() (sqlo.query.select.SelectQuery method)
rows_between() (sqlo.Window method)
S
select() (sqlo.Q static method)
SelectQuery (class in sqlo.query.select)
set() (sqlo.query.update.UpdateQuery method)
set_debug() (sqlo.Q class method)
set_dialect() (sqlo.Q class method)
sqlo
module
sqlo.expressions
module
sqlo.query.delete
module
sqlo.query.insert
module
sqlo.query.select
module
sqlo.query.update
module
sum() (sqlo.expressions.FunctionFactory static method)
U
union() (sqlo.query.select.SelectQuery method)
union_all() (sqlo.query.select.SelectQuery method)
update() (sqlo.Q static method)
UpdateQuery (class in sqlo.query.update)
use_index() (sqlo.query.select.SelectQuery method)
V
values() (sqlo.query.insert.InsertQuery method)
W
when() (sqlo.query.select.SelectQuery method)
where() (sqlo.query.delete.DeleteQuery method)
(sqlo.query.select.SelectQuery method)
(sqlo.query.update.UpdateQuery method)
where_between() (sqlo.query.select.SelectQuery method)
where_in() (sqlo.query.select.SelectQuery method)
where_like() (sqlo.query.select.SelectQuery method)
where_not_between() (sqlo.query.select.SelectQuery method)
where_not_in() (sqlo.query.select.SelectQuery method)
where_not_like() (sqlo.query.select.SelectQuery method)
where_not_null() (sqlo.query.select.SelectQuery method)
where_null() (sqlo.query.select.SelectQuery method)
Window (class in sqlo)