Adding support for latest Postgres version

Roadmap

Existing v12 Functions and Miscellaneous

• Aggregate

  • AVG, BIT_AND, BIT_OR, BOOL_AND, BOOL_OR, COUNT, EVERY, MAX, MIN, SUM

• Support Alias

• Between Operation

• Binary Operation

  • Arithmetic, Bit, Comparison, Logical, Range

• CAST

• COLLATE

• CONCAT

• IN

• JOIN

  • INNER, LEFT, RIGHT, FULL, CROSS

• LIKE

• ORDER BY

• Regular Expression

• POSTFIX

• SELECT

• SIMILAR

• WINDOW

  • ROW_NUMBER, RANK, DENSE_RANK, PERCENT_RANK, CUME_DIST, NTILE, LAG, LEAD, FIRST_VALUE, LAST_VALUE, NTH_VALUE

• DELETE

• DISCARD

• ALTER

• ANALYZE

• COMMENT

• DROP INDEX

• CREATE INDEX

• INSERT

• NOTIFY

• REINDEX

• STATISTICS

• TRANSACTIONS

• TRUNCATE

• UPDATE

• VACUUM

• VIEW

• CTE

Key Changes to Each Version

V13

No significant changes

V14

Add support for multirange such as INT4MULTIRANGE

Implement SEARCH/CYCLE clause on many cases such as CTE

Implement OUT parameters for stored procedures

Remove CREATE ON SELECT and implement CREATE VIEW ref

V15

Add support for MERGE keyword

V16

Parallelization?

V17

Implement new JSON functions

• JSON_TABLE, JSON_EXISTS, JSON_QUERY, JSON_VALUE

Miscellaneous Changes

• Metadata catalog

• New data types

• Configuration on parameters

• Error messages

• Deprecation and legacy system

• Syntax changes