Skip to content

Issues: kayak/pypika

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Clear current search query, filters, and sorts
173 Open 264 Closed
173 Open 264 Closed
Author
Filter by author
Loading
Label
Filter by label
Loading
Use alt + click/return to exclude labels
or ⇧ + click/return for logical OR
Projects
Filter by project
Loading
Milestones
Filter by milestone
Loading
Assignee
Filter by who’s assigned
Sort
Sort by
Newest Oldest Most commented Least commented Recently updated Least recently updated Best match
Most reactions
👍 👎 😄 🎉 😕 ❤️ 🚀 👀

Issues list

update BasicCriterion.__bool__ to prevent chained comparisons
#712 opened Nov 23, 2022 by thinkingatoms updated Nov 23, 2022
Recursion Error while building large SQL statement
#646 opened Oct 19, 2021 by ceandrade updated Dec 2, 2022
2
Add additional body statements/table options to query builders
#714 opened Dec 5, 2022 by hmlamad updated Dec 5, 2022
How to use user defined ENUM class in WHERE clause using PostgreSQL?
#715 opened Dec 22, 2022 by swapnilsaha-me updated Dec 22, 2022
sql escape bug
#706 opened Oct 11, 2022 by liu071900 updated Jan 7, 2023
1
Double quotes inconsistency in WITH clause
#710 opened Nov 10, 2022 by gandroz updated Jan 23, 2023
1
Union performed on two other _SetOperation type queries throws error when get_sql() is called.
#716 opened Jan 23, 2023 by tripti-nference updated Jan 23, 2023
Decorators in utils do not preserve function signature
#717 opened Jan 31, 2023 by DavideWalder updated Jan 31, 2023
Using a table alias on delete generates invalid SQL syntax
#718 opened Feb 13, 2023 by tijm-wolters updated Feb 13, 2023
isin method should not use narrow isinstance for generating criterion
#668 opened Feb 11, 2022 by JordanReiter updated Mar 26, 2023
1
Implementation of a StaticValue class
#719 opened Feb 13, 2023 by GregoirePelegrin updated Apr 1, 2023
1
NullCriterion's term should add parentheses for sql
#724 opened Apr 7, 2023 by xinglin-zhao updated Apr 7, 2023
with clause nested query.
#683 opened May 24, 2022 by nishantkshyp2004 updated Apr 11, 2023
1
Bug when using EmptyCriterion in ComplexCriterion
#327 opened Oct 2, 2019 by jialonso updated Apr 19, 2023
3
Support for SELECT * EXCEPT/EXCLUDE
#726 opened Apr 24, 2023 by aersam updated Apr 24, 2023
Using python object ipaddress.IPv4Address leads to incorrect SQL.
#727 opened May 9, 2023 by maksim-nik updated May 9, 2023
Pagination style (slice vs limit/offset)
#731 opened Jun 8, 2023 by noxxer updated Jun 8, 2023
psycopg2/postgresql throws ambiguous column error because groupby clause doesn't generate with namespaces set correctly
#728 opened May 25, 2023 by jpjagt updated Jun 24, 2023
ComplexCriterion does not use aliases
#673 opened Mar 2, 2022 by MarkusShepherd updated Jul 7, 2023
3
Alias not being specified for complex criteria
#521 opened Nov 11, 2020 by jcoetzee updated Jul 7, 2023
2
No JSON_VALID(val) in pypika
#736 opened Jul 19, 2023 by infosansofty updated Jul 19, 2023
1
Clickhouse WITH <expression> AS <identifier>
#745 opened Sep 5, 2023 by ArtyomSavostin updated Sep 6, 2023
1
Fix with_alias argument in terms classes
#616 opened Jul 13, 2021 by AnghileriDavide updated Sep 7, 2023
3
SnowflakeQuery missing in pypika.dialects
#741 opened Aug 10, 2023 by deragon updated Sep 8, 2023
1
Feature: COPY for PostgreSQL
#702 opened Sep 10, 2022 by Pk13055 updated Sep 8, 2023
2
ProTip! Updated in the last three days: updated:>2025-01-24.