Skip to content

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

7.0 KB
Raw Blame
- description: Simple JOIN
  statement: SELECT u.id, u.name, o.order_id FROM users u JOIN orders o ON u.id = o.user_id;
  defaultDatabase: catalog1
  metadata: '{"name":"catalog1","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"id","type":"integer"},{"name":"name","type":"varchar"}]},{"name":"orders","columns":[{"name":"order_id","type":"integer"},{"name":"user_id","type":"integer"}]}]}]}'
  querySpan:
    type:
        querytype: 1
    results:
        - name: u.id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: u.name
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: o.order_id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
    sourceColumns:
        catalog1.public.orders.order_id: true
        catalog1.public.orders.user_id: true
        catalog1.public.users.id: true
        catalog1.public.users.name: true
    predicateColumns: {}
- description: LEFT JOIN
  statement: SELECT u.id, u.name, o.order_id FROM users u LEFT JOIN orders o ON u.id = o.user_id;
  defaultDatabase: catalog1
  metadata: '{"name":"catalog1","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"id","type":"integer"},{"name":"name","type":"varchar"}]},{"name":"orders","columns":[{"name":"order_id","type":"integer"},{"name":"user_id","type":"integer"}]}]}]}'
  querySpan:
    type:
        querytype: 1
    results:
        - name: u.id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: u.name
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: o.order_id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
    sourceColumns:
        catalog1.public.orders.order_id: true
        catalog1.public.orders.user_id: true
        catalog1.public.users.id: true
        catalog1.public.users.name: true
    predicateColumns: {}
- description: RIGHT JOIN
  statement: SELECT u.id, u.name, o.order_id FROM users u RIGHT JOIN orders o ON u.id = o.user_id;
  defaultDatabase: catalog1
  metadata: '{"name":"catalog1","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"id","type":"integer"},{"name":"name","type":"varchar"}]},{"name":"orders","columns":[{"name":"order_id","type":"integer"},{"name":"user_id","type":"integer"}]}]}]}'
  querySpan:
    type:
        querytype: 1
    results:
        - name: u.id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: u.name
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: o.order_id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
    sourceColumns:
        catalog1.public.orders.order_id: true
        catalog1.public.orders.user_id: true
        catalog1.public.users.id: true
        catalog1.public.users.name: true
    predicateColumns: {}
- description: FULL OUTER JOIN
  statement: SELECT u.id, u.name, o.order_id FROM users u FULL OUTER JOIN orders o ON u.id = o.user_id;
  defaultDatabase: catalog1
  metadata: '{"name":"catalog1","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"id","type":"integer"},{"name":"name","type":"varchar"}]},{"name":"orders","columns":[{"name":"order_id","type":"integer"},{"name":"user_id","type":"integer"}]}]}]}'
  querySpan:
    type:
        querytype: 1
    results:
        - name: u.id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: u.name
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: o.order_id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
    sourceColumns:
        catalog1.public.orders.order_id: true
        catalog1.public.orders.user_id: true
        catalog1.public.users.id: true
        catalog1.public.users.name: true
    predicateColumns: {}
- description: CROSS JOIN
  statement: SELECT u.id, u.name, o.order_id FROM users u CROSS JOIN orders o;
  defaultDatabase: catalog1
  metadata: '{"name":"catalog1","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"id","type":"integer"},{"name":"name","type":"varchar"}]},{"name":"orders","columns":[{"name":"order_id","type":"integer"},{"name":"user_id","type":"integer"}]}]}]}'
  querySpan:
    type:
        querytype: 1
    results:
        - name: u.id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: u.name
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: o.order_id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
    sourceColumns:
        catalog1.public.orders.order_id: true
        catalog1.public.orders.user_id: true
        catalog1.public.users.id: true
        catalog1.public.users.name: true
    predicateColumns: {}
- description: Multiple JOINs
  statement: SELECT u.id, u.name, o.order_id, i.item_name FROM users u JOIN orders o ON u.id = o.user_id JOIN order_items i ON o.order_id = i.order_id;
  defaultDatabase: catalog1
  metadata: '{"name":"catalog1","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"id","type":"integer"},{"name":"name","type":"varchar"}]},{"name":"orders","columns":[{"name":"order_id","type":"integer"},{"name":"user_id","type":"integer"}]},{"name":"order_items","columns":[{"name":"order_id","type":"integer"},{"name":"item_name","type":"varchar"}]}]}]}'
  querySpan:
    type:
        querytype: 1
    results:
        - name: u.id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: u.name
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: o.order_id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: i.item_name
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
    sourceColumns:
        catalog1.public.order_items.item_name: true
        catalog1.public.order_items.order_id: true
        catalog1.public.orders.order_id: true
        catalog1.public.orders.user_id: true
        catalog1.public.users.id: true
        catalog1.public.users.name: true
    predicateColumns: {}