CHANGELOG

* Add support for array operators
* Remove the parentheses around the unary and binary operators
* Use the ordinal number as aliases for GROUP BY
* Check the coherence of the aliases of GROUP BY and ORDER BY expressions
* Do not use parameter for EXTRACT field
* Remove support for Python older than 3.6

Version 1.7.0 - 2025-11-24
* Add support for Python 3.14
* Do not use parameters for COUNT(*)

Version 1.6.0 - 2025-05-02
* Fix position of order_by parameters in Select query
* Add support for weak reference on SQL objects
* Add support for Python 3.13

Version 1.5.2 - 2024-09-30
* Use parameter for unary operator
* Support default values when inserting not matched merge
* Replace assert by ValueError

Version 1.5.1 - 2024-05-28
* Use parameter for start and end of WINDOW FRAME
* Use parameter for limit and offset

Version 1.5.0 - 2024-05-13
* Skip alias on INSERT without ON CONFLICT or RETURNING
* Add MERGE
* Support UPSERT
* Remove default escape char on LIKE and ILIKE
* Add GROUPING SETS, CUBE, and ROLLUP

Version 1.4.3 - 2023-12-30
* Render common table expression in combining query
* Add support for Python 3.12

Version 1.4.2 - 2023-06-25
* Restore usage of alias in returning expression

Version 1.4.1 - 2023-06-16
* Do not use alias in returning expression

Version 1.4.0 - 2022-05-02
* Use unittest discover
* Use only column name for INSERT and UPDATE
* Add escape to Like operators
* Add default literal '*' expression to Count
* Add support for Python 3.10

Version 1.3.0 - 2021-09-14
* Add GROUPS frame to Window
* Add exclude to Window
* Add method for each type of join
* Remove support for Python older than 3.5
* Support Select queries in conditionals and functions

Version 1.2.2 - 2021-05-16
* Escape table and column names containing double quote
* Use alias on the main table used in UPDATE and INSERT
* Add support for Python 3.9

Version 1.2.1 - 2020-10-08
* Fix AttributeError in Select.params with windows

Version 1.2.0 - 2020-10-05
* Add explicit Windows to Select
* Fix missing Windows definitions in nested expressions

Version 1.1.0 - 2020-01-25
* Add ORDER BY clause to aggregate functions
* Add support for Python 3.8
* Add distinct on Select

Version 1.0.0 - 2018-09-30
* Add Flavor filter_ to fallback to case expression
* Allow to use expression in AtTimeZone
* Fix Select query in returning
* Add comparison predicates
* Add COLLATE

Version 0.9 - 2017-04-24
* Add distinct_on on Select
* Allow to use Select as Column of Select query
* Support Select without from clause

Version 0.8 - 2015-09-19
* Add DISTINCT qualifier to aggregate expressions
* Allow to order on select queries
* Add NULL ordering
* Use UPPER to simulate missing ILIKE
* Add CURRENT_DATE function
* Fix DateTrunc function name
* Add no_boolean Flavor
* Add converter format2numeric
* Add rownum limit style
* Add no_as Flavor

Version 0.7 - 2015-05-19
* Fix WINDOW and HAVING params order in Select
* Add window functions
* Add filter and within group to aggregate
* Add limitstyle with 'offset' and 'limit'
* Add Lateral

Version 0.6 - 2015-02-05
* Fix Delete query under multithread
* Add missing quote for with query name

Version 0.5 - 2015-01-29
* Add schema
* Add Common Table Expression
* Escape Mod operator '%' with format paramstyle
* Deprecate Interesect in favor of Intersect
* Add Values

Version 0.4 - 2014-08-03
* Fix Mapping in Trim function
* Add __truediv__ alias of __div__ for Python3
* Fix For tables setter when tables is not a list
* Allow to add Table to existing From list
* Fix Select with for_ clause
* Add Null alias for None
* Add missing format of operand in Unary operator

Version 0.3 - 2014-01-31
* Add returning to Update
* Add missing params for returning
* Add columns definitions to Function
* Fix AtTimeZone mapping

Version 0.2 - 2013-09-18
* Fix usage mixture between Div operator and function
* Add array support in operators

Version 0.1 - 2013-08-28
* Initial release