Chores, chores and chores. This will be probably the last release based on the Pydantic 1.x.
🌈 Pink fluffy unicorns dancing on rainbows 🌈
- Changed: Dropped support for Python 3.7 and 3.8
- Added: Ability to use casting for
ORDER BY
property
- Fixed: Corrected cast of JSON fields
- Feature:
FirstValue
window function introduced - Feature: Positional
ArrayAgg
introduced
- Change: Ability to cast to UUID
- Feature: More benevolent type nesting
- Feature:
Case
introduced (without docs, there was no time, sry, let's call it Easter Egg for a while)
- Fix: Fixed problem with multiple properties in operations (I had to remove comparison property check)
- Fix: Fixed nested conditions (
Operator
can contain anotherOperator
) - Change: Dropped Python 3.6 support
- Fix: Use
->
instead of-->
- Fix: Use
-->
operator in JSON lookup chaining in nested objects
- Feature: Nested JSON fields
- Fix: Use
->>
operator in JSON lookup instead of->
(cast result as text)
- Fix: Use quotes in JSON column type keys in
Property
- Feature: Now is possible to pass
Distinct
toCount
to haveCOUNT(DISTINCT property)
syntax in pSQL - Tests: Test for JSON column type in pSQL
- Fix: Use native
typing.Literal
if possible (Python 3.8 compatibility fix)
- Feature:
lower
function introduced - Feature:
upper
function introduced - Feature: pSQL
initcap
function introduced
- Feature:
QueryFactory
supportingjson
,msgpack
andbson
- Feature: pSQL
unaccent
function introduced
- Feature:
Extract.Unit.DAY
introduced - Feature:
CastOperator.DataType.REAL
introduced - Feature: pSQL
to_char
function introduced - Feature: pSQL
to_date
function introduced
- Feature:
HAVING
support - Feature:
NOW()
support - Fix:
Comparision
allows to have everyBaseType
asproperties
- Fix: Interval value is quoted now
- Change: Ability to pass
structures.Distinct
intofunctions.StringAgg
- Fix: Fixed JOIN aliases
Project renamed to duckql
, this is the first public release (development status modifier changed to beta).
- Change: Name changed to
duckql
- Change: Poetry as package manager
- Feature: Subquery support
- Note: Changelog datetimes in ISO 8601 compatible
Y-m-d
format
- Fix: Adding missing imports in
__init__.py
files inside of submodules - Change: Moved
__version__
from__init__.py
toversion.py
- Note: Development status change to Alpha
- Feature: Introduced
functions.StringAgg
- Feature: Introduced
structures.CastOperator
- Feature: CLI for parsing files
- Change: Allow direct use of
structures.Comparision
in query conditions
- Fix: Allow aliases in
structures.Query
- Change: Do not escape
%
- Feature: Natural join support
- Change: Completed docs
- Feature: Recursive nested properties lookup in
Query
object
- Change: Default values for optional attributes in
structures.Query
- Change:
custom_parser
now can raiseParseError
if there is invalid object type passed
- Initial release