Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

100 KB
Raw Blame
- input: |-
    select count(1) from t1 where id 'asdfsadf'; SELECT * FROM |
    select * from QRTZ_J0B_DETAILS qjd where J0B_NAME like '%gray';
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: INSERT INTO t1(|);
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: INSERT INTO t2(c1, |);
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: WITH x(x1, x2) AS (SELECT * FROM t2) SELECT x.| FROM x;
  want:
    - text: x1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: x2
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
- input: WITH x(x1, x2) AS (SELECT * FROM t2) SELECT | FROM x
  want:
    - text: x1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: x2
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: x
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 as eid, c2 as xid FROM t2 ORDER BY |
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: eid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: xid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 as eid FROM t1 ORDER BY |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: eid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT FROM basdkfjasldf;SELECT | FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM (SELECT c1 FROM t1) cc1(cc1c1)
  want:
    - text: cc1c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: cc1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM (SELECT c1 FROM t1) cc1
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: cc1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: |-
    SELECT
    FROM |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: |-
    SELECT

    FROM |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT FROM |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT FROM t1 WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT FROM t1 ORDER BY |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT FROM t1 GROUP BY |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT FROM t1 JOIN |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: UPDATE |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: UPDATE t1 SET |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DELETE FROM |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: INSERT INTO |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER TABLE |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DROP TABLE |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM db.|
  want:
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 JOIN |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1, |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * from t1 cc1 JOIN t2 on cc1.|
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT MAX(cc1.|) FROM t2 cc1
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t2 x
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: x
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT DISTINCT | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t2 LIMIT 10
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1, | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: |-
    SELECT
      |
    FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: |-
    SELECT *
    FROM
      |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT   *   FROM   |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM /* comment */ |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: |-
    SELECT * FROM t1 -- comment
    WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t2 FOR UPDATE
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT t1.| FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT cc1.| FROM t2 cc1
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT cc1.| FROM t1 cc1 JOIN t2 ON NOT cc1.c1 = t2.c1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT db.t2.| FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT a.| FROM t1 a JOIN t1 b ON a.c1 = b.c1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT b.| FROM t1 a JOIN t1 b ON a.c1 = b.c1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT COUNT(|) FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t1 JOIN t2 ON t1.c1 = t2.c1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 cc1 JOIN t2 ON cc1.c1 = t2.|
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT | FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t1 RIGHT JOIN t2 ON t1.c1 = t2.c1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t1 CROSS JOIN t2
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t1 NATURAL JOIN t2
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t1 a JOIN t2 b ON a.c1 = b.c1 JOIN t2 c ON b.c1 = c.c1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: a
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: b
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: c
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c.| FROM t1 a JOIN t2 b ON a.c1 = b.c1 JOIN t2 c ON b.c1 = c.c1
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM t1 RIGHT JOIN t2 ON t1.c1 = t2.|
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM t1 CROSS JOIN t2 WHERE t1.|
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM t1 JOIN t2 ON t1.c1 = t2.c1 LEFT JOIN t2 t3 ON t2.c1 = t3.c1 WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t3
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT a.| FROM t1 a NATURAL JOIN t2 b
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM t1 LEFT JOIN |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t1 JOIN t2 ON t1.c1 = t2.c1 LEFT JOIN t2 t3 ON t2.c1 = t3.c1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t3
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 JOIN t2 USING (|)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT x.| FROM (SELECT * FROM t2) x
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM (SELECT * FROM (SELECT c1 FROM t1) inner_q) outer_q
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: outer_q
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM (SELECT c1 FROM t1) sub1 JOIN t2 ON sub1.c1 = t2.c1
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: sub1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM (SELECT c1 FROM (SELECT c1 FROM (SELECT c1 FROM t1) a) b) c
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: c
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT b.| FROM (SELECT * FROM (SELECT c1 FROM t1) a) b
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
- input: (SELECT c1 FROM t1) UNION (SELECT | FROM t2)
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 WHERE c1 IN (SELECT | FROM t2)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 WHERE EXISTS (SELECT | FROM t2)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 WHERE c1 = (SELECT MAX(|) FROM t2)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 x WHERE x.c1 IN (SELECT c1 FROM t2 WHERE |)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: x
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 WHERE EXISTS (SELECT 1 FROM t2 WHERE t2.c1 = t1.|)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT (SELECT | FROM t1) FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: WITH a AS (SELECT c1 FROM t1), b AS (SELECT c1, c2 FROM t2) SELECT | FROM a JOIN b ON a.c1 = b.c1
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: a
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: b
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: WITH a AS (SELECT c1 FROM t1), b AS (SELECT c1, c2 FROM t2) SELECT b.| FROM a JOIN b ON a.c1 = b.c1
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
- input: WITH x AS (SELECT c1 FROM t1) SELECT | FROM (SELECT * FROM x) sub1
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: sub1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: x
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: With a AS (SELECT c1 FROM t1), b AS (SELECT * FROM a) SELECT | FROM b
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: a
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: b
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: With a AS (SELECT c1 FROM t1), b AS (SELECT a.| FROM a) SELECT * FROM b
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
- input: WITH x AS (SELECT c1 FROM t1) SELECT | FROM x, t2
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: x
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: WITH x AS (SELECT c1 FROM t1) SELECT x.| FROM x JOIN t2 ON x.c1 = t2.c1
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
- input: WITH x(a, b) AS (SELECT c1, c2 FROM t2) SELECT | FROM x JOIN t1 ON x.a = t1.c1
  want:
    - text: a
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: b
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: x
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: WITH x AS (SELECT * FROM t2) INSERT INTO t1 SELECT | FROM x
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: x
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: WITH x AS (SELECT c1, c2 FROM t2) UPDATE t1 SET c1 = (SELECT | FROM x)
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: x
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: WITH x AS (SELECT * FROM t2) DELETE FROM t1 WHERE c1 IN (SELECT | FROM x)
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: x
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: WITH RECURSIVE x AS (SELECT c1 FROM t1 UNION ALL SELECT c1 FROM x) SELECT | FROM x
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: x
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: WITH x AS (SELECT c1 FROM t1 UNION SELECT c1 FROM t2) SELECT x.| FROM x
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 WHERE c1 = 1 AND |
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 WHERE (c1 = 1 AND |)
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 WHERE c1 IS NOT NULL AND |
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 WHERE c1 IS NULL OR |
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 WHERE NOT |
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 WHERE c1 > |
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 WHERE c1 + | > 0
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 WHERE c1 IN (1, 2) AND |
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 WHERE c1 BETWEEN | AND c2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 WHERE c1 BETWEEN c2 AND |
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 WHERE c1 LIKE |
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 WHERE CASE WHEN c1 > 0 THEN | END = 1
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 a JOIN t2 b ON a.c1 = b.c1 WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: a
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: b
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 a JOIN t2 b ON a.c1 = b.c1 WHERE a.|
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
- input: |-
    SELECT
    FROM t1
    WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 as eid FROM t1 WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 as eid FROM t1 GROUP BY |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: eid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 as eid, c2 as xid FROM t2 HAVING |
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: eid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: xid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 FROM t1 UNION SELECT c1 FROM t2 ORDER BY |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 FROM t1 UNION ALL SELECT c1 FROM t2 ORDER BY |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 LIMIT |
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 ORDER BY c1 LIMIT |
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: INSERT INTO db.|
  want:
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: INSERT INTO t1 SELECT | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: INSERT INTO t1 VALUES (|)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT 1; INSERT INTO |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: UPDATE | SET c1 = 1
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: UPDATE db.|
  want:
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: UPDATE t1 SET c1 = |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: UPDATE t1 SET c1 = 1 WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DELETE FROM db.|
  want:
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DELETE FROM t1 WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT 1; UPDATE |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT 1; DELETE FROM |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DELETE FROM t1 WHERE c1 > 0 AND |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER TABLE db.|
  want:
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER TABLE t1 ADD COLUMN c2 int REFERENCES |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER TABLE t1 DROP COLUMN |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER TABLE t1 RENAME COLUMN | TO new_name
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER TABLE t1 MODIFY COLUMN |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER TABLE t1 ADD CONSTRAINT fk FOREIGN KEY (|) REFERENCES t2
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER TABLE t1 ADD CONSTRAINT fk FOREIGN KEY (c1) REFERENCES t2(|)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DROP TABLE db.|
  want:
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DROP TABLE IF EXISTS |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DROP VIEW |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DROP INDEX |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
- input: TRUNCATE TABLE |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE TABLE t3 (id int, FOREIGN KEY (id) REFERENCES |)
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE TABLE t3 (id int REFERENCES t1(|))
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE INDEX idx ON |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE INDEX idx ON t1 (|)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE INDEX idx ON t2 (c1, |)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE VIEW v2 AS SELECT | FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE VIEW v2 AS SELECT * FROM |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE TABLE t3 AS SELECT | FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 FROM t1 UNION SELECT | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 FROM t1 UNION ALL SELECT | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 FROM t1 INTERSECT SELECT | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 FROM t1 EXCEPT SELECT | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 FROM t1 UNION SELECT c1 FROM t1 UNION SELECT | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 FROM t1 EXCEPT ALL SELECT | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 FROM t1 INTERSECT ALL SELECT | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t2 UNION SELECT * FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM (SELECT c1 FROM t1 UNION SELECT c1 FROM t2) x WHERE x.|
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM (SELECT c1, c2 FROM t2 UNION SELECT c1, c2 FROM t2) sub
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: sub
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: INVALID SQL; SELECT * FROM |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1; SELECT * FROM t2 WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT; SELECT | FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 WHERE; SELECT | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE TABLE x (id int); SELECT | FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT 1; UPDATE |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT 1; DELETE FROM |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t|
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM db.t|
  want:
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT t1.c|
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
- input: INSERT INTO t|
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: UPDATE t|
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DELETE FROM t|
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 JOIN t|
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 WHERE t1.c|
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
- input: ALTER TABLE t|
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DROP TABLE t|
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM `t1`
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT `t1`.| FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM `db`.|
  want:
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM `db`.`t1` WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: "SELECT\t|\tFROM t1"
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: 'SELECT * FROM t1 WHERE | '
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: |-
    SELECT
      *
      FROM
      t1
      WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: /* leading comment */ SELECT * FROM |
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 WHERE c1 = /* inline */ |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: INSERT INTO `t1`(|)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1, SUM(c2) OVER (PARTITION BY |) FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1, SUM(c2) OVER (ORDER BY |) FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1, ROW_NUMBER() OVER (PARTITION BY | ORDER BY c1) FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT COALESCE(|, 0) FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT COALESCE(c1, |) FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT NULLIF(|, 0) FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT CAST(| AS int) FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT IF(|, 1, 0) FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT IFNULL(|, 0) FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 as 'eid' FROM t1 ORDER BY |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: eid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT c1 as "xid" FROM t1 ORDER BY |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: xid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t2 AS Foo WHERE foo.|
  want:
    - text: c1
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: t2 | , NOT NULL
      comment: ""
      priority: 0
- input: WITH Foo AS (SELECT c1 FROM t1) SELECT foo.| FROM Foo
  want:
- input: ALTER TABLE t1 DROP COLUMN |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER TABLE t1 RENAME COLUMN | TO new_name
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER TABLE db.t1 DROP COLUMN |
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: INSERT IGNORE t1 (|) VALUES (1)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: INSERT IGNORE INTO t1 (|) VALUES (1)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: REPLACE INTO t1 (|) VALUES (1)
  want:
    - text: c1
      type: COLUMN
      definition: t1 | , NOT NULL
      comment: ""
      priority: 0
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DROP VIEW db.|
  want:
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM other_db.t2
  want:
    - text: db
      type: DATABASE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0