Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- description: Case insensitive table name
statement: SELECT id, name FROM Users;
defaultDatabase: catalog1
ignoreCaseSensitive: true
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: Case insensitive column names
statement: SELECT ID, Name FROM users;
defaultDatabase: catalog1
ignoreCaseSensitive: true
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: Case insensitive schema name
statement: SELECT id, name FROM PUBLIC.users;
defaultDatabase: catalog1
ignoreCaseSensitive: true
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: Case sensitive with quoted identifiers
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: {}