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: Join Alias and Asterisk
statement: SELECT t.* FROM MyTable1 t JOIN MyTable2 u ON t.a = u.c;
defaultDatabase: db
ignoreCaseSensitive: true
metadata:
- |-
{
"name": "db",
"schemas": [
{
"name": "dbo",
"tables": [
{
"name": "MyTable1",
"columns": [
{
"name": "a"
},
{
"name": "b"
}
]
},
{
"name": "MyTable2",
"columns": [
{
"name": "c"
},
{
"name": "d"
}
]
}
]
}
]
}
querySpan:
type: 1
results:
- name: a
sourcecolumns:
- server: ""
database: db
schema: dbo
table: MyTable1
column: a
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
- name: b
sourcecolumns:
- server: ""
database: db
schema: dbo
table: MyTable1
column: b
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
sourcecolumns:
- server: ""
database: db
schema: dbo
table: MyTable1
column: ""
- server: ""
database: db
schema: dbo
table: MyTable2
column: ""
predicatecolumns:
- server: ""
database: db
schema: dbo
table: MyTable1
column: a
- server: ""
database: db
schema: dbo
table: MyTable2
column: c
- description: Join Alias
statement: SELECT t.a, t.b FROM MyTable1 t JOIN MyTable2 u ON t.a = u.c;
defaultDatabase: db
ignoreCaseSensitive: true
metadata:
- |-
{
"name": "db",
"schemas": [
{
"name": "dbo",
"tables": [
{
"name": "MyTable1",
"columns": [
{
"name": "a"
},
{
"name": "b"
}
]
},
{
"name": "MyTable2",
"columns": [
{
"name": "c"
},
{
"name": "d"
}
]
}
]
}
]
}
querySpan:
type: 1
results:
- name: a
sourcecolumns:
- server: ""
database: db
schema: dbo
table: MyTable1
column: a
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
- name: b
sourcecolumns:
- server: ""
database: db
schema: dbo
table: MyTable1
column: b
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
sourcecolumns:
- server: ""
database: db
schema: dbo
table: MyTable1
column: ""
- server: ""
database: db
schema: dbo
table: MyTable2
column: ""
predicatecolumns:
- server: ""
database: db
schema: dbo
table: MyTable1
column: a
- server: ""
database: db
schema: dbo
table: MyTable2
column: c