TODO.md

TODOs

• Insert, update, delete statements:
  • Add Insert statement
    • Support WITH queries
    • Support OVERRIDING { SYSTEM | USER } VALUE clause
    • Support DEFAULT VALUES
    • Support .Query to add a SELECT statement
    • Support ON CONFLICT clause
      • Suppport SetColumnList to set column names from expressions or a sub-select
    • Support RETURNING clause
  • Add Update statement
    • Support WITH queries
    • Suppport SetColumnList to set column names from expressions or a sub-select
    • Support FROM clause for joins
    • Support WHERE CURRENT OF cursor_name clause
    • Support RETURNING clause
  • Add Delete statement
    • Support WITH queries
    • Support ONLY and table_name *
    • Support USING clause
    • Support WHERE CURRENT OF cursor_name clause
    • Support RETURNING clause
• Select:
  • Support locking clauses
  • Support window functions
• Expression:
  • Make sure ExpBase is returned / embedded by literals to enable building of expressions
  • Implement more functions and operators from https://www.postgresql.org/docs/15/functions.html
    • IN with subquery
    • IN with scalar expressions
    • EXISTS
    • ...
• Reduce exported types on qrb package
• Check if we want to add .As() to N to improve select lists and from clauses
  • Not sure for now, since output names and aliases, column aliases and column definitions differ between select lists, from items and functions