Skip to content

Latest commit

 

History

History
63 lines (44 loc) · 1.16 KB

ROADMAP.md

File metadata and controls

63 lines (44 loc) · 1.16 KB
Raw

Roadmap

SQL dialects

There are several SQL dialects that this project can eventually cover:

  • MariaDB 10.2.13 / MySQL 5.7
  • PostgreSQL
  • MSSQL
  • Oracle

You are welcome to contribute on the development to other dialects.

MariaDB / MySQL

SQL Parser:

  • CREATE DATABASE
    • CHARACTER SET
    • COLLATION
  • CREATE TABLE
    • COLUMN DEFINITIONS / KEYS / INDEX
    • CREATE TABLE OPTIONS
    • CREATE TABLE LIKE
  • CREATE INDEX
  • ALTER DATABASE
  • ALTER TABLE
  • DROP DATABASE
  • DROP INDEX
  • DROP TABLE
  • RENAME TABLE

Postparser, JSON formatter:

  • Compact JSON format
  • JSON Schema format

More complex features are not priority, as they require parsing SELECT statements or expressions* ...

  • CREATE TABLE AS (EXPRESSION)*
  • CREATE TABLE GENERATED AS (EXPRESSION) columns
  • CREATE TABLE partition options
  • CREATE VIEW
  • ALTER VIEW
  • DROP VIEW
  • CHECK CONSTRAINTS**
  • Expressions as column default values (MariaDB only)

* https://dev.mysql.com/doc/refman/5.7/en/expressions.html

** https://mariadb.com/kb/en/library/constraint/

PostgreSQL

TODO

MSSQL

TODO

Oracle

TODO