Skip to content

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

214 KB
Raw Blame
- input: SELECT * FROM |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM public.|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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 test.|
  want:
    - text: order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 public.t1
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 test.auto
  want:
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: users
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT cc1.| FROM t2 cc1
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, 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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT public.t2.| FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT | FROM t1 JOIN t2 ON t1.c1 = t2.c1
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM t1 cc1 JOIN t2 ON cc1.c1 = t2.|
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, 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: public.t1 | int, 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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT | FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 test.auto c ON b.c1 = c.id
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: a
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: auto
      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: users
      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 test.auto c ON b.c1 = c.id
  want:
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
- input: SELECT | FROM (SELECT c1 FROM t1) cc1
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: WITH x AS (SELECT * FROM t2) SELECT x.| FROM x;
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: SELECT * FROM t1 WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 test.auto WHERE |
  want:
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM test.auto WHERE test.auto.|
  want:
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
- input: SELECT c1 as eid FROM t1 WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM t1 WHERE c1 IN (SELECT | FROM t2)
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: eid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 ORDER BY |
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: eid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: xid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: eid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: eid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: xid
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 ORDER BY x.|
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM t2 x GROUP BY x.|
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT MAX(cc1.|) FROM t2 cc1
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT COUNT(|) FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: INSERT INTO test.| VALUES (1)
  want:
    - text: order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
- input: INSERT INTO t1 (|) VALUES (1)
  want:
    - text: c1
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: UPDATE test.|
  want:
    - text: order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
- input: UPDATE t1 SET |
  want:
    - text: c1
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DELETE FROM |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DELETE FROM test.|
  want:
    - text: order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
- input: DELETE FROM t1 WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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;SELECT * FROM |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 count(1) from t1 where id; SELECT * FROM |
    select * from QRTZ_J0B_DETAILS qjd where J0B_NAME like '%gray';
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 v1
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t1 JOIN test.auto ON t1.c1 = test.auto.id
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: users
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 * FROM t1 JOIN test.auto a ON t1.c1 = a.id WHERE a.|
  want:
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
- input: SELECT | FROM t1 RIGHT JOIN t2 ON t1.c1 = t2.c1
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 FULL OUTER JOIN t2 ON t1.c1 = t2.c1
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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.|
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM t1 FULL OUTER JOIN t2 ON t1.c1 = t2.|
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM t1 CROSS JOIN t2 WHERE t1.|
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM t1 JOIN t2 USING (|)
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 test.auto ON t2.c1 = test.auto.id
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: users
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM t2 WHERE c1 BETWEEN | AND c2
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 test.auto WHERE name LIKE |
  want:
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: users
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 t2 WHERE CASE WHEN c1 > 0 THEN | END = 1
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 DISTINCT | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 DISTINCT ON (|) c1, c2 FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 OFFSET |
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 t2 WHERE c1 > 0 RETURNING |
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 t2 SET c1 = 1 RETURNING |
  want:
    - text: c1
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 ft1 WHERE |
  want:
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: ft1
      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 mv1 WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      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 public.ft1 WHERE |
  want:
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: ft1
      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 public.mv1 WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      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 ft1.| FROM ft1
  want:
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
- input: SELECT | FROM ft1
  want:
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: ft1
      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 mv1.| FROM mv1
  want:
    - text: c1
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
- input: SELECT | FROM mv1
  want:
    - text: c1
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      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: INSERT INTO |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: UPDATE | SET c1 = 1
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE TABLE test_tbl (id int, FOREIGN KEY (id) REFERENCES |)
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE TABLE test_tbl (id int, FOREIGN KEY (id) REFERENCES public.|)
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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 test_tbl (id int REFERENCES |)
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE TABLE test_tbl (id int REFERENCES t1(|))
  want:
    - text: c1
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE INDEX idx ON |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE INDEX idx ON public.|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE MATERIALIZED VIEW mv AS SELECT | FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 test_tbl AS SELECT | FROM t1
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 test_tbl (LIKE |)
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE TRIGGER trig AFTER INSERT ON |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: CREATE TRIGGER trig AFTER INSERT ON public.|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER TABLE public.|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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 COLUMN c2 int REFERENCES |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER TABLE t1 ALTER COLUMN |
  want:
    - text: c1
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER TABLE t1 ALTER COLUMN | SET NOT NULL
  want:
    - text: c1
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER INDEX | RENAME TO new_name
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER VIEW |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER VIEW public.|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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 SEQUENCE |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: ALTER SEQUENCE public.|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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 MATERIALIZED VIEW |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DROP TABLE |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DROP TABLE public.|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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 IF EXISTS |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DROP VIEW |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DROP VIEW public.|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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 INDEX |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DROP SEQUENCE |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DROP MATERIALIZED VIEW |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: TRUNCATE |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: TRUNCATE public.|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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: COMMENT ON TABLE |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: COMMENT ON TABLE public.|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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: COMMENT ON COLUMN t1.|
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: COMMENT ON COLUMN public.t1.|
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: GRANT SELECT ON |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: GRANT SELECT ON public.|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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: GRANT ALL ON ALL TABLES IN SCHEMA |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: REVOKE SELECT ON |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: REVOKE SELECT ON public.|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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: GRANT USAGE ON SEQUENCE |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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 | FROM x JOIN t1 ON x.c1 = t1.c1) SELECT * FROM x
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 x.| FROM x JOIN t1 ON x.c1 = t1.c1) SELECT * FROM x
  want:
- input: WITH x AS (SELECT * FROM t2) INSERT INTO t1 SELECT | FROM x
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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, LATERAL (SELECT | FROM t2 WHERE t2.c1 = t1.c1) sub
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: SELECT sub.| FROM t1, LATERAL (SELECT c1, c2 FROM t2 WHERE t2.c1 = t1.c1) sub
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
- input: SELECT | FROM t1 LEFT JOIN LATERAL (SELECT * FROM t2 WHERE t2.c1 = t1.c1) sub ON true
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: SELECT * FROM t1, LATERAL (SELECT t1.| FROM t2) sub
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM t2 x, LATERAL (SELECT x.| FROM t1) sub
  want:
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT | FROM generate_series(1, 10) g
  want:
    - text: c1
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.mv1
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f1
      type: COLUMN
      definition: public.ft1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: f2
      type: COLUMN
      definition: public.ft1 | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: id
      type: COLUMN
      definition: test.auto | int, NOT NULL
      comment: ""
      priority: 0
    - text: name
      type: COLUMN
      definition: test.auto | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: user_id
      type: COLUMN
      definition: test.users | int, NOT NULL
      comment: ""
      priority: 0
    - text: username
      type: COLUMN
      definition: test.users | varchar, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT g.| FROM generate_series(1, 10) g
  want:
- input: SELECT | FROM t1, generate_series(1, 10) g
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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, LATERAL (SELECT * FROM t1 WHERE t1.c1 = x.c1) sub
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: x
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT (SELECT | FROM t1) FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 t1.| FROM t1) FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM t1 WHERE c1 = ANY(SELECT | FROM t2)
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 = ALL(SELECT | FROM t2)
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 * FROM (SELECT | FROM t1) a) b
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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 b.| FROM (SELECT * FROM (SELECT c1 FROM t1) a) b
  want:
    - text: c1
      type: COLUMN
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 WHERE EXISTS (SELECT 1 FROM t2 WHERE t2.c1 = t1.|)
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: SELECT sub.| 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
- input: SELECT c1 FROM t1 INTERSECT SELECT | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: 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 c1 FROM t1 EXCEPT ALL SELECT | FROM t2
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c1
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM "public".|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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 public."t1" WHERE |
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM public.t|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      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.c|
  want:
    - text: c1
      type: COLUMN
      definition: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: SELECT * FROM test.a|
  want:
    - text: order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM tes|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
- input: INSERT INTO t|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: UPDATE t|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: DELETE FROM t|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT * FROM t1 JOIN t|
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT 1; INSERT INTO |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT 1; UPDATE |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: SELECT 1; DELETE FROM |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: v1
      type: VIEW
      definition: ""
      comment: ""
      priority: 0
- input: INVALID SQL; SELECT * FROM |
  want:
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: c2
      type: COLUMN
      definition: public.t2 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: seq1
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: test.order_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: user_id_seq
      type: SEQUENCE
      definition: ""
      comment: ""
      priority: 0
    - text: t1
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: t2
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.auto
      type: TABLE
      definition: ""
      comment: ""
      priority: 0
    - text: test.users
      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: public.t1 | int, NOT NULL
      comment: ""
      priority: 0
    - text: ft1
      type: FOREIGNTABLE
      definition: ""
      comment: ""
      priority: 0
    - text: mv1
      type: MATERIALIZEDVIEW
      definition: ""
      comment: ""
      priority: 0
    - text: public
      type: SCHEMA
      definition: ""
      comment: ""
      priority: 0
    - text: test
      type: SCHEMA
      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