PyPika
stable
Installation
Tutorial
Advanced Query Features
Window Frames
Extending PyPika
API Reference
PyPika
Docs
»
Index
Edit on GitHub
Index
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
L
|
M
|
N
|
O
|
P
|
Q
|
R
|
S
|
T
|
U
|
V
|
W
|
X
|
Y
A
add (pypika.enums.Arithmetic attribute)
add_order (pypika.terms.ArithmeticExpression attribute)
AggregateFunction (class in pypika.terms)
alias_sql() (in module pypika.utils)
all (pypika.enums.UnionType attribute)
AnalyticFunction (class in pypika.terms)
and_ (pypika.enums.Boolean attribute)
Arithmetic (class in pypika.enums)
ArithmeticExpression (class in pypika.terms)
as_() (pypika.terms.Term method)
asc (pypika.enums.Order attribute)
Ascii (class in pypika.functions)
Avg (class in pypika.functions)
B
BasicCriterion (class in pypika.terms)
between() (pypika.terms.Term method)
BetweenCriterion (class in pypika.terms)
Bin (class in pypika.functions)
bin_regex (pypika.enums.Matching attribute)
bin_regex() (pypika.terms.Term method)
Boolean (class in pypika.enums)
builder() (in module pypika.utils)
C
Case (class in pypika.terms)
CaseException
Cast (class in pypika.functions)
Coalesce (class in pypika.functions)
columns() (pypika.queries.QueryBuilder method)
Comparator (class in pypika.enums)
ComplexCriterion (class in pypika.terms)
Concat (class in pypika.functions)
ContainsCriterion (class in pypika.terms)
Convert (class in pypika.functions)
Count (class in pypika.functions)
Criterion (class in pypika.terms)
CurDate (class in pypika.functions)
CurTime (class in pypika.functions)
D
Date (class in pypika.functions)
DATE (pypika.enums.SqlTypes attribute)
DateAdd (class in pypika.functions)
DateDiff (class in pypika.functions)
DatePart (class in pypika.enums)
day (pypika.enums.DatePart attribute)
delete() (pypika.queries.QueryBuilder method)
desc (pypika.enums.Order attribute)
DialectNotSupported
Dialects (class in pypika.enums)
distinct (pypika.enums.UnionType attribute)
distinct() (pypika.functions.Count method)
(pypika.queries.QueryBuilder method)
div (pypika.enums.Arithmetic attribute)
do_join() (pypika.queries.QueryBuilder method)
E
else_() (pypika.terms.Case method)
eq (pypika.enums.Equality attribute)
eq() (pypika.terms.Term method)
Equality (class in pypika.enums)
Extract (class in pypika.functions)
F
Field (class in pypika.terms)
field() (pypika.queries.Selectable method)
fields() (pypika.queries.QueryBuilder method)
(pypika.terms.ArithmeticExpression method)
(pypika.terms.BasicCriterion method)
(pypika.terms.BetweenCriterion method)
(pypika.terms.Case method)
(pypika.terms.ComplexCriterion method)
(pypika.terms.ContainsCriterion method)
(pypika.terms.Criterion method)
(pypika.terms.Function method)
(pypika.terms.Interval method)
(pypika.terms.Not method)
(pypika.terms.NullCriterion method)
(pypika.terms.NullValue method)
(pypika.terms.Term method)
(pypika.terms.Tuple method)
(pypika.terms.ValueWrapper method)
for_() (pypika.terms.ArithmeticExpression method)
(pypika.terms.BasicCriterion method)
(pypika.terms.BetweenCriterion method)
(pypika.terms.Field method)
(pypika.terms.Function method)
(pypika.terms.NullCriterion method)
from_() (pypika.queries.Query class method)
(pypika.queries.QueryBuilder method)
Function (class in pypika.terms)
G
get_frame_sql() (pypika.terms.WindowFrameAnalyticFunction method)
get_function_sql() (pypika.functions.Count method)
(pypika.terms.AnalyticFunction method)
(pypika.terms.Function method)
get_partition_sql() (pypika.terms.AnalyticFunction method)
(pypika.terms.WindowFrameAnalyticFunction method)
get_special_params_sql() (pypika.functions.Cast method)
(pypika.functions.Convert method)
(pypika.functions.Extract method)
(pypika.terms.Function method)
(pypika.terms.IgnoreNullsAnalyticFunction method)
get_sql() (pypika.queries.Join method)
(pypika.queries.JoinOn method)
(pypika.queries.JoinUsing method)
(pypika.queries.QueryBuilder method)
(pypika.queries.Table method)
(pypika.terms.ArithmeticExpression method)
(pypika.terms.BasicCriterion method)
(pypika.terms.BetweenCriterion method)
(pypika.terms.Case method)
(pypika.terms.ComplexCriterion method)
(pypika.terms.ContainsCriterion method)
(pypika.terms.Criterion method)
(pypika.terms.Field method)
(pypika.terms.Function method)
(pypika.terms.Interval method)
(pypika.terms.Not method)
(pypika.terms.NullCriterion method)
(pypika.terms.NullValue method)
(pypika.terms.Star method)
(pypika.terms.Term method)
(pypika.terms.Tuple method)
(pypika.terms.ValueWrapper method)
groupby() (pypika.queries.QueryBuilder method)
GroupingException
gt (pypika.enums.Equality attribute)
gt() (pypika.terms.Term method)
gte (pypika.enums.Equality attribute)
gte() (pypika.terms.Term method)
H
having() (pypika.queries.QueryBuilder method)
hour (pypika.enums.DatePart attribute)
I
ignore() (pypika.queries.QueryBuilder method)
ignore_nulls() (pypika.terms.IgnoreNullsAnalyticFunction method)
ignoredeepcopy() (in module pypika.utils)
IgnoreNullsAnalyticFunction (class in pypika.terms)
inner (pypika.enums.JoinType attribute)
Insert (class in pypika.functions)
insert() (pypika.queries.QueryBuilder method)
Interval (class in pypika.terms)
into() (pypika.queries.Query class method)
(pypika.queries.QueryBuilder method)
is_aggregate (pypika.terms.AggregateFunction attribute)
(pypika.terms.ArithmeticExpression attribute)
(pypika.terms.Case attribute)
(pypika.terms.Term attribute)
(pypika.terms.ValueWrapper attribute)
is_analytic (pypika.terms.AnalyticFunction attribute)
isin() (pypika.terms.Term method)
isnull() (pypika.terms.Term method)
J
Join (class in pypika.queries)
join() (pypika.queries.QueryBuilder method)
Joiner (class in pypika.queries)
JoinException
JoinOn (class in pypika.queries)
JoinType (class in pypika.enums)
JoinUsing (class in pypika.queries)
L
labels (pypika.terms.Interval attribute)
left (pypika.enums.JoinType attribute)
Length (class in pypika.functions)
like (pypika.enums.Matching attribute)
like() (pypika.terms.Term method)
limit() (pypika.queries.QueryBuilder method)
Lower (class in pypika.functions)
lt (pypika.enums.Equality attribute)
lt() (pypika.terms.Term method)
lte (pypika.enums.Equality attribute)
lte() (pypika.terms.Term method)
M
make_tables() (in module pypika.queries)
Matching (class in pypika.enums)
Max (class in pypika.functions)
microsecond (pypika.enums.DatePart attribute)
Min (class in pypika.functions)
minute (pypika.enums.DatePart attribute)
Mod (class in pypika.terms)
month (pypika.enums.DatePart attribute)
MSSQL (pypika.enums.Dialects attribute)
mul (pypika.enums.Arithmetic attribute)
mul_order (pypika.terms.ArithmeticExpression attribute)
MYSQL (pypika.enums.Dialects attribute)
N
ne (pypika.enums.Equality attribute)
ne() (pypika.terms.Term method)
needs_brackets() (pypika.terms.ComplexCriterion method)
negate() (pypika.terms.ContainsCriterion method)
(pypika.terms.Term method)
Not (class in pypika.terms)
notin() (pypika.terms.Term method)
notnull() (pypika.terms.Term method)
Now (class in pypika.functions)
NullCriterion (class in pypika.terms)
NullIf (class in pypika.functions)
NullValue (class in pypika.terms)
O
offset() (pypika.queries.QueryBuilder method)
on() (pypika.queries.Joiner method)
on_field() (pypika.queries.Joiner method)
or_ (pypika.enums.Boolean attribute)
ORACLE (pypika.enums.Dialects attribute)
Order (class in pypika.enums)
orderby() (pypika.queries.QueryBuilder method)
(pypika.terms.AnalyticFunction method)
outer (pypika.enums.JoinType attribute)
over() (pypika.terms.AnalyticFunction method)
P
POSTGRESQL (pypika.enums.Dialects attribute)
Pow (class in pypika.terms)
pypika (module)
pypika.enums (module)
pypika.functions (module)
pypika.queries (module)
pypika.terms (module)
pypika.utils (module)
Q
quarter (pypika.enums.DatePart attribute)
Query (class in pypika.queries)
QueryBuilder (class in pypika.queries)
QueryException
R
range() (pypika.terms.WindowFrameAnalyticFunction method)
REDSHIFT (pypika.enums.Dialects attribute)
regex (pypika.enums.Matching attribute)
regex() (pypika.terms.Term method)
RegexpLike (class in pypika.functions)
RegexpMatches (class in pypika.functions)
resolve_is_aggregate() (in module pypika.utils)
Reverse (class in pypika.functions)
right (pypika.enums.JoinType attribute)
Rollup (class in pypika.terms)
rollup() (pypika.queries.QueryBuilder method)
RollupException
rows() (pypika.terms.WindowFrameAnalyticFunction method)
S
second (pypika.enums.DatePart attribute)
select() (pypika.queries.Query class method)
(pypika.queries.QueryBuilder method)
Selectable (class in pypika.queries)
set() (pypika.queries.QueryBuilder method)
Signed (class in pypika.functions)
SIGNED (pypika.enums.SqlTypes attribute)
SplitPart (class in pypika.functions)
SqlTypes (class in pypika.enums)
Star (class in pypika.terms)
star (pypika.queries.Selectable attribute)
Std (class in pypika.functions)
StdDev (class in pypika.functions)
sub (pypika.enums.Arithmetic attribute)
Substring (class in pypika.functions)
Sum (class in pypika.functions)
T
Table (class in pypika.queries)
tables_ (pypika.terms.ArithmeticExpression attribute)
(pypika.terms.BasicCriterion attribute)
(pypika.terms.BetweenCriterion attribute)
(pypika.terms.Field attribute)
(pypika.terms.Function attribute)
(pypika.terms.NullCriterion attribute)
(pypika.terms.Term attribute)
Term (class in pypika.terms)
Timestamp (class in pypika.functions)
TIMESTAMP (pypika.enums.SqlTypes attribute)
TimestampAdd (class in pypika.functions)
ToChar (class in pypika.functions)
Trim (class in pypika.functions)
trim_pattern (pypika.terms.Interval attribute)
Tuple (class in pypika.terms)
U
union() (pypika.queries.QueryBuilder method)
union_all() (pypika.queries.QueryBuilder method)
UnionException
UnionType (class in pypika.enums)
units (pypika.terms.Interval attribute)
Unsigned (class in pypika.functions)
UNSIGNED (pypika.enums.SqlTypes attribute)
update() (pypika.queries.Query class method)
(pypika.queries.QueryBuilder method)
Upper (class in pypika.functions)
using() (pypika.queries.Joiner method)
utf8 (pypika.enums.SqlTypes attribute)
V
validate() (pypika.queries.JoinOn method)
(pypika.queries.JoinUsing method)
ValueWrapper (class in pypika.terms)
VARCHAR (pypika.enums.SqlTypes attribute)
VERTICA (pypika.enums.Dialects attribute)
W
week (pypika.enums.DatePart attribute)
when() (pypika.terms.Case method)
where() (pypika.queries.QueryBuilder method)
WindowFrameAnalyticFunction (class in pypika.terms)
WindowFrameAnalyticFunction.Edge (class in pypika.terms)
X
xor_ (pypika.enums.Boolean attribute)
Y
year (pypika.enums.DatePart attribute)
Read the Docs
v: stable
Versions
latest
stable
Downloads
pdf
htmlzip
epub
On Read the Docs
Project Home
Builds
Free document hosting provided by
Read the Docs
.