issues
search
kayak
/
pypika
PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
http://pypika.readthedocs.io/en/latest/
Apache License 2.0
2.43k
stars
292
forks
source link
issues
Newest
Newest
Most commented
Recently updated
Oldest
Least commented
Least recently updated
Contributing guidelines
#758
wd60622
closed
8 months ago
10
fix: make pypika compatible with PEP 561
#757
fedetibaldo
opened
9 months ago
1
PostgreSQLQuery: Can't use WITH with DELETE USING
#756
wont-work
opened
9 months ago
0
Cannot join with a Query
#755
JonathanCabezas
closed
8 months ago
3
feat: Support limiting row count and offsets in Oracle queries
#754
danielenricocahall
closed
2 months ago
25
feat: Support creating/dropping indices on tables
#753
tazarov
closed
9 months ago
13
refactor: CI
#752
gavindsouza
closed
9 months ago
7
autoincrement int with create_table()
#751
Krogsager
opened
9 months ago
0
MSSQL - CROSS APPLY implementation
#750
WY-CGhilardi
opened
9 months ago
0
Wrapper to fix typing
#749
Pyrolistical
opened
9 months ago
2
Add pre-commit hook to lint the code
#748
AzisK
closed
9 months ago
1
CI: Python 3.6 Build
#747
gavindsouza
closed
9 months ago
2
Fix: Don't wrap set operations in brackets in SQLite
#746
nwrahnema
opened
10 months ago
2
Clickhouse WITH <expression> AS <identifier>
#745
ArtyomSavostin
opened
10 months ago
1
Fix: Allow the usage of `frozenset` in the `isin(...)` and `notin(...)` functions
#744
antoninkriz
closed
9 months ago
3
Select from values in insert in Snowflake
#743
jeffarrubla
closed
10 months ago
1
fix `Field.__init__`
#742
WH-2099
closed
2 months ago
2
SnowflakeQuery missing in pypika.dialects
#741
deragon
opened
10 months ago
1
fix: Typing hint for builder decorator
#740
gavindsouza
closed
9 months ago
10
Sub Queries and CTE not working on MS SQL Server Dialect
#739
SawiSawaiz
opened
11 months ago
1
Sub Queries do not work for MS SQL Dialect
#738
SawiSawaiz
closed
11 months ago
0
Status of Repository
#737
kme1018
opened
11 months ago
14
No JSON_VALID(val) in pypika
#736
infosansofty
opened
11 months ago
1
with_alias handling missing in various criterion
#735
Ga68
opened
12 months ago
1
Vertica alias use fix
#734
Ga68
closed
9 months ago
2
Vertica alias fix
#733
Ga68
closed
12 months ago
1
fix(terms): fixed EmptyCriterion bug with ComplexCriterion
#732
GeorgiySurkov
closed
9 months ago
4
Pagination style (slice vs limit/offset)
#731
noxxer
opened
1 year ago
0
Add null ordering params to order by clause
#730
0x726f
opened
1 year ago
0
`QueryBuilder` with `dialect` set performs differently than dialect specific builder
#729
matteo-zanoni
opened
1 year ago
3
psycopg2/postgresql throws ambiguous column error because groupby clause doesn't generate with namespaces set correctly
#728
jpjagt
opened
1 year ago
0
Using python object ipaddress.IPv4Address leads to incorrect SQL.
#727
maksim-nik
opened
1 year ago
0
Support for SELECT * EXCEPT/EXCLUDE
#726
aersam
opened
1 year ago
0
simple insert_dict() builder
#725
edvardm
opened
1 year ago
1
NullCriterion's term should add parentheses for sql
#724
xinglin-zhao
opened
1 year ago
0
Add a `pipe` method
#723
wd60622
closed
5 months ago
0
Add force index for joins
#722
RonNabuurs
opened
1 year ago
0
Initial support for JQL
#721
doc-sheet
opened
1 year ago
6
Implementation of StaticValue class
#720
GregoirePelegrin
opened
1 year ago
0
Implementation of a StaticValue class
#719
GregoirePelegrin
opened
1 year ago
1
Using a table alias on delete generates invalid SQL syntax
#718
tijm-wolters
opened
1 year ago
0
Decorators in utils do not preserve function signature
#717
DavideWalder
opened
1 year ago
0
Union performed on two other _SetOperation type queries throws error when get_sql() is called.
#716
tripti-nference
opened
1 year ago
0
How to use user defined ENUM class in WHERE clause using PostgreSQL?
#715
swapnilsaha-me
opened
1 year ago
0
Add additional body statements/table options to query builders
#714
hmlamad
opened
1 year ago
0
Fix set with_namespace as False forcibly _set_sql() #675
#713
cattybaby723
opened
1 year ago
0
update BasicCriterion.__bool__ to prevent chained comparisons
#712
thinkingatoms
opened
1 year ago
0
Query with date conversion
#711
imnileshd
closed
1 year ago
1
Double quotes inconsistency in WITH clause
#710
gandroz
opened
1 year ago
1
CTE using subquery over direct select statement
#709
alexf-bond
opened
1 year ago
1
Previous
Next