PyPika
latest
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
Abs (class in pypika.functions)
add (pypika.enums.Arithmetic attribute)
add_order (pypika.terms.ArithmeticExpression attribute)
AggregateFunction (class in pypika.terms)
ALIAS_QUOTE_CHAR (pypika.queries.CreateQueryBuilder attribute)
(pypika.queries.QueryBuilder attribute)
AliasedQuery (class in pypika.queries)
all (pypika.enums.UnionType attribute)
all() (pypika.terms.Criterion static method)
AnalyticFunction (class in pypika.terms)
and_ (pypika.enums.Boolean attribute)
any() (pypika.terms.Criterion static method)
ApproximatePercentile (class in pypika.functions)
Arithmetic (class in pypika.enums)
ArithmeticExpression (class in pypika.terms)
Array (class in pypika.terms)
as_() (pypika.queries.Selectable method)
(pypika.terms.Term method)
as_select() (pypika.queries.CreateQueryBuilder 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)
BINARY (pypika.enums.SqlTypes attribute)
bitwiseand() (pypika.terms.Term method)
BitwiseAndCriterion (class in pypika.terms)
Boolean (class in pypika.enums)
BOOLEAN (pypika.enums.SqlTypes attribute)
Bracket (class in pypika.terms)
builder() (in module pypika.utils)
C
Case (class in pypika.terms)
CaseException
Cast (class in pypika.functions)
CHAR (pypika.enums.SqlTypes attribute)
CLICKHOUSE (pypika.enums.Dialects attribute)
Coalesce (class in pypika.functions)
Column (class in pypika.queries)
columns() (pypika.queries.CreateQueryBuilder method)
(pypika.queries.QueryBuilder method)
Comparator (class in pypika.enums)
ComplexCriterion (class in pypika.terms)
Concat (class in pypika.functions)
CONTAINED_BY (pypika.enums.JSONOperators attribute)
contained_by() (pypika.terms.JSON method)
CONTAINS (pypika.enums.JSONOperators attribute)
contains() (pypika.terms.JSON method)
ContainsCriterion (class in pypika.terms)
Convert (class in pypika.functions)
Count (class in pypika.functions)
create_table() (pypika.queries.CreateQueryBuilder method)
(pypika.queries.Query class method)
CreateQueryBuilder (class in pypika.queries)
Criterion (class in pypika.terms)
cross (pypika.enums.JoinType attribute)
cross() (pypika.queries.Joiner method)
cross_join() (pypika.queries.QueryBuilder method)
CurDate (class in pypika.functions)
CurTime (class in pypika.functions)
CurTimestamp (class in pypika.functions)
CustomFunction (class in pypika.terms)
D
Database (class in pypika.queries)
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.DistinctOptionFunction method)
(pypika.queries.QueryBuilder method)
DistinctOptionFunction (class in pypika.functions)
div (pypika.enums.Arithmetic attribute)
do_join() (pypika.queries.QueryBuilder method)
E
else_() (pypika.terms.Case method)
EmptyCriterion (class in pypika.terms)
eq (pypika.enums.Equality attribute)
eq() (pypika.terms.Term method)
Equality (class in pypika.enums)
Extract (class in pypika.functions)
F
false (pypika.enums.Boolean attribute)
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.BitwiseAndCriterion 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.NestedCriterion method)
(pypika.terms.Not method)
(pypika.terms.NullCriterion method)
(pypika.terms.NullValue method)
(pypika.terms.Parameter method)
(pypika.terms.PseudoColumn method)
(pypika.terms.Term method)
(pypika.terms.Tuple method)
(pypika.terms.ValueWrapper method)
First (class in pypika.functions)
FLOAT (pypika.enums.SqlTypes attribute)
Floor (class in pypika.functions)
force_index() (pypika.queries.QueryBuilder method)
format_alias_sql() (in module pypika.utils)
format_quotes() (in module pypika.utils)
from_() (pypika.queries.Query class method)
(pypika.queries.QueryBuilder method)
full_outer (pypika.enums.JoinType attribute)
Function (class in pypika.terms)
FunctionException
G
get_frame_sql() (pypika.terms.WindowFrameAnalyticFunction method)
get_function_sql() (pypika.functions.CurTimestamp method)
(pypika.functions.DistinctOptionFunction method)
(pypika.terms.AnalyticFunction method)
(pypika.terms.Function method)
GET_JSON_VALUE (pypika.enums.JSONOperators attribute)
get_json_value() (pypika.terms.JSON method)
get_partition_sql() (pypika.terms.AnalyticFunction method)
(pypika.terms.WindowFrameAnalyticFunction method)
GET_PATH_JSON_VALUE (pypika.enums.JSONOperators attribute)
get_path_json_value() (pypika.terms.JSON method)
GET_PATH_TEXT_VALUE (pypika.enums.JSONOperators attribute)
get_path_text_value() (pypika.terms.JSON method)
get_special_params_sql() (pypika.functions.ApproximatePercentile method)
(pypika.functions.Cast method)
(pypika.functions.Convert method)
(pypika.functions.Extract method)
(pypika.terms.Function method)
(pypika.terms.IgnoreNullsAnalyticFunction method)
get_sql() (pypika.enums.SqlType method)
(pypika.enums.SqlTypeLength method)
(pypika.queries.AliasedQuery method)
(pypika.queries.Column method)
(pypika.queries.CreateQueryBuilder method)
(pypika.queries.Join method)
(pypika.queries.JoinOn method)
(pypika.queries.JoinUsing method)
(pypika.queries.QueryBuilder method)
(pypika.queries.Schema method)
(pypika.queries.Table method)
(pypika.terms.ArithmeticExpression method)
(pypika.terms.Array method)
(pypika.terms.BasicCriterion method)
(pypika.terms.BetweenCriterion method)
(pypika.terms.BitwiseAndCriterion method)
(pypika.terms.Bracket 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.Index method)
(pypika.terms.Interval method)
(pypika.terms.JSON method)
(pypika.terms.Negative method)
(pypika.terms.NestedCriterion method)
(pypika.terms.Not method)
(pypika.terms.NullCriterion method)
(pypika.terms.NullValue method)
(pypika.terms.Parameter method)
(pypika.terms.PseudoColumn method)
(pypika.terms.Star method)
(pypika.terms.Term method)
(pypika.terms.Tuple method)
(pypika.terms.ValueWrapper method)
(pypika.terms.Values method)
GET_TEXT_VALUE (pypika.enums.JSONOperators attribute)
get_text_value() (pypika.terms.JSON method)
get_value_sql() (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
HAS_ANY_KEYS (pypika.enums.JSONOperators attribute)
has_any_keys() (pypika.terms.JSON method)
HAS_KEY (pypika.enums.JSONOperators attribute)
has_key() (pypika.terms.JSON method)
HAS_KEYS (pypika.enums.JSONOperators attribute)
has_keys() (pypika.terms.JSON method)
having() (pypika.queries.QueryBuilder method)
hour (pypika.enums.DatePart attribute)
I
IfNull (class in pypika.functions)
ignore() (pypika.queries.QueryBuilder method)
ignore_copy() (in module pypika.utils)
ignore_nulls() (pypika.terms.IgnoreNullsAnalyticFunction method)
IgnoreNullsAnalyticFunction (class in pypika.terms)
ilike (pypika.enums.Matching attribute)
ilike() (pypika.terms.Term method)
Index (class in pypika.terms)
inner (pypika.enums.JoinType attribute)
inner_join() (pypika.queries.QueryBuilder method)
Insert (class in pypika.functions)
insert() (pypika.queries.QueryBuilder method)
(pypika.queries.Table method)
INTEGER (pypika.enums.SqlTypes attribute)
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.BasicCriterion attribute)
(pypika.terms.BetweenCriterion attribute)
(pypika.terms.Case attribute)
(pypika.terms.ContainsCriterion attribute)
(pypika.terms.EmptyCriterion attribute)
(pypika.terms.Function attribute)
(pypika.terms.Negative attribute)
(pypika.terms.NestedCriterion attribute)
(pypika.terms.Parameter attribute)
(pypika.terms.Term attribute)
(pypika.terms.Tuple attribute)
(pypika.terms.ValueWrapper attribute)
is_analytic (pypika.terms.AnalyticFunction attribute)
is_joined() (pypika.queries.QueryBuilder method)
isin() (pypika.terms.Term method)
IsNull (class in pypika.functions)
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)
JSON (class in pypika.terms)
JSONOperators (class in pypika.enums)
L
labels (pypika.terms.Interval attribute)
Last (class in pypika.functions)
left (pypika.enums.JoinType attribute)
left_join() (pypika.queries.QueryBuilder method)
left_outer (pypika.enums.JoinType attribute)
Length (class in pypika.functions)
like (pypika.enums.Matching attribute)
like() (pypika.terms.Term method)
limit() (pypika.queries.QueryBuilder method)
LONG_VARBINARY (pypika.enums.SqlTypes attribute)
LONG_VARCHAR (pypika.enums.SqlTypes attribute)
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_columns() (in module pypika.queries)
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)
Negative (class in pypika.terms)
NestedCriterion (class in pypika.terms)
Not (class in pypika.terms)
not_ilike (pypika.enums.Matching attribute)
not_ilike() (pypika.terms.Term method)
not_like (pypika.enums.Matching attribute)
not_like() (pypika.terms.Term method)
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)
NUMERIC (pypika.enums.SqlTypes attribute)
NVL (class in pypika.functions)
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)
outer_join() (pypika.queries.QueryBuilder method)
over() (pypika.terms.AnalyticFunction method)
P
Parameter (class in pypika.terms)
POSTGRESQL (pypika.enums.Dialects attribute)
Pow (class in pypika.terms)
prewhere() (pypika.queries.QueryBuilder method)
PseudoColumn (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
QUOTE_CHAR (pypika.queries.CreateQueryBuilder attribute)
(pypika.queries.QueryBuilder attribute)
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)
replace() (pypika.queries.QueryBuilder method)
replace_table() (pypika.queries.Join method)
(pypika.queries.JoinOn method)
(pypika.queries.JoinUsing method)
(pypika.queries.QueryBuilder method)
(pypika.terms.ArithmeticExpression method)
(pypika.terms.BasicCriterion method)
(pypika.terms.BetweenCriterion method)
(pypika.terms.BitwiseAndCriterion method)
(pypika.terms.Case method)
(pypika.terms.ContainsCriterion method)
(pypika.terms.Field method)
(pypika.terms.Function method)
(pypika.terms.NestedCriterion method)
(pypika.terms.Not method)
(pypika.terms.NullCriterion method)
(pypika.terms.Term method)
(pypika.terms.Tuple method)
resolve_is_aggregate() (in module pypika.utils)
Reverse (class in pypika.functions)
right (pypika.enums.JoinType attribute)
right_join() (pypika.queries.QueryBuilder method)
right_outer (pypika.enums.JoinType attribute)
Rollup (class in pypika.terms)
rollup() (pypika.queries.QueryBuilder method)
RollupException
rows() (pypika.terms.WindowFrameAnalyticFunction method)
S
Schema (class in pypika.queries)
second (pypika.enums.DatePart attribute)
SECONDARY_QUOTE_CHAR (pypika.queries.CreateQueryBuilder attribute)
(pypika.queries.QueryBuilder attribute)
select() (pypika.queries.Query class method)
(pypika.queries.QueryBuilder method)
(pypika.queries.Table method)
Selectable (class in pypika.queries)
set() (pypika.queries.QueryBuilder method)
Signed (class in pypika.functions)
SIGNED (pypika.enums.SqlTypes attribute)
SNOWFLAKE (pypika.enums.Dialects attribute)
SplitPart (class in pypika.functions)
SQLLITE (pypika.enums.Dialects attribute)
SqlType (class in pypika.enums)
SqlTypeLength (class in pypika.enums)
SqlTypes (class in pypika.enums)
Sqrt (class in pypika.functions)
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)
table (pypika.terms.JSON attribute)
tables_ (pypika.terms.ArithmeticExpression attribute)
(pypika.terms.BasicCriterion attribute)
(pypika.terms.BetweenCriterion attribute)
(pypika.terms.BitwiseAndCriterion attribute)
(pypika.terms.Case attribute)
(pypika.terms.ContainsCriterion attribute)
(pypika.terms.EmptyCriterion attribute)
(pypika.terms.Field attribute)
(pypika.terms.Function attribute)
(pypika.terms.Interval attribute)
(pypika.terms.NestedCriterion attribute)
(pypika.terms.Not attribute)
(pypika.terms.NullCriterion attribute)
(pypika.terms.Star attribute)
(pypika.terms.Term attribute)
templates (pypika.terms.Interval attribute)
temporary() (pypika.queries.CreateQueryBuilder method)
Term (class in pypika.terms)
TIME (pypika.enums.SqlTypes attribute)
TimeDiff (class in pypika.functions)
Timestamp (class in pypika.functions)
TIMESTAMP (pypika.enums.SqlTypes attribute)
TimestampAdd (class in pypika.functions)
ToChar (class in pypika.functions)
ToDate (class in pypika.functions)
Trim (class in pypika.functions)
trim_pattern (pypika.terms.Interval attribute)
true (pypika.enums.Boolean 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)
(pypika.queries.Table method)
Upper (class in pypika.functions)
using() (pypika.queries.Joiner method)
UtcTimestamp (class in pypika.functions)
V
validate() (in module pypika.utils)
(pypika.queries.Join method)
(pypika.queries.JoinOn method)
(pypika.queries.JoinUsing method)
Values (class in pypika.terms)
ValueWrapper (class in pypika.terms)
VARBINARY (pypika.enums.SqlTypes attribute)
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)
with_() (pypika.queries.Query class method)
(pypika.queries.QueryBuilder method)
with_totals() (pypika.queries.QueryBuilder method)
wrap_constant() (pypika.terms.Term static method)
wrap_json() (pypika.terms.Term static method)
X
xor_ (pypika.enums.Boolean attribute)
Y
year (pypika.enums.DatePart attribute)
Read the Docs
v: latest
Versions
latest
stable
Downloads
pdf
html
epub
On Read the Docs
Project Home
Builds
Free document hosting provided by
Read the Docs
.