Skip to content

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

2.2 KB
Raw Blame
- description: Simple SELECT
  statement: SELECT id, name FROM users;
  defaultDatabase: catalog1
  metadata: '{"name":"catalog1","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"id","type":"integer"},{"name":"name","type":"varchar"}]}]}]}'
  querySpan:
    type:
        querytype: 1
    results:
        - name: id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: name
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
    sourceColumns:
        catalog1.public.users.id: true
        catalog1.public.users.name: true
    predicateColumns: {}
- description: SELECT with alias
  statement: SELECT u.id AS user_id, u.name FROM users u;
  defaultDatabase: catalog1
  metadata: '{"name":"catalog1","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"id","type":"integer"},{"name":"name","type":"varchar"}]}]}]}'
  querySpan:
    type:
        querytype: 1
    results:
        - name: user_id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: u.name
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
    sourceColumns:
        catalog1.public.users.id: true
        catalog1.public.users.name: true
    predicateColumns: {}
- description: SELECT from schema.table
  statement: SELECT id, name FROM public.users;
  defaultDatabase: catalog1
  metadata: '{"name":"catalog1","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"id","type":"integer"},{"name":"name","type":"varchar"}]}]}]}'
  querySpan:
    type:
        querytype: 1
    results:
        - name: id
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
        - name: name
          sourceColumns: {}
          isPlainField: false
          sourceFieldPaths: []
          selectAsterisk: false
    sourceColumns:
        catalog1.public.users.id: true
        catalog1.public.users.name: true
    predicateColumns: {}