Skip to content

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

74.2 KB
Raw Blame
- description: Named Schema
  statement: SELECT * FROM MySchema.Customers JOIN Orders ON Customers.Id = Orders.CustomerId;
  defaultDatabase: maskingdb
  metadata: |-
    {
      "name":  "maskingdb",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "Orders",
              "columns":  [
                {
                  "name":  "CustomerId"
                }
              ]
            }
          ]
        },
         {
          "name": "MySchema",
          "tables":  [
            {
              "name":  "Customers",
              "columns":  [
                {
                  "name":  "Id"
                },
                {
                  "name":  "Name"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: Id
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: MySchema
            table: Customers
            column: Id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: Name
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: MySchema
            table: Customers
            column: Name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: CustomerId
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Orders
            column: CustomerId
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: maskingdb
        schema: MySchema
        table: Customers
        column: ""
      - server: ""
        database: maskingdb
        schema: ""
        table: Orders
        column: ""
    predicatecolumns: []
- description: Except and replace
  statement: SELECT * EXCEPT (ID) REPLACE (ID/2 AS NAME) FROM people;
  defaultDatabase: ds1
  metadata: |-
    {
      "name":  "ds1",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "people",
              "columns":  [
                {
                  "name":  "ID"
                },
                {
                  "name":  "NAME"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: NAME
        sourcecolumns:
          - server: ""
            database: ds1
            schema: ""
            table: people
            column: ID
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: ds1
        schema: ""
        table: people
        column: ""
    predicatecolumns: []
- description: Set operation
  statement: WITH CTE_1 AS (SELECT * FROM people), CTE_2 AS (SELECT * FROM address) SELECT * FROM CTE_1 UNION ALL SELECT * FROM CTE_2;
  defaultDatabase: ds1
  metadata: |-
    {
      "name":  "ds1",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "PEOPLE",
              "columns":  [
                {
                  "name":  "ID"
                },
                {
                  "name":  "NAME"
                }
              ]
            },
            {
              "name":  "ADDRESS",
              "columns":  [
                {
                  "name":  "PEOPLE_ID"
                },
                {
                  "name":  "ADDRESS"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: ds1
            schema: ""
            table: ADDRESS
            column: PEOPLE_ID
          - server: ""
            database: ds1
            schema: ""
            table: PEOPLE
            column: ID
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: NAME
        sourcecolumns:
          - server: ""
            database: ds1
            schema: ""
            table: ADDRESS
            column: ADDRESS
          - server: ""
            database: ds1
            schema: ""
            table: PEOPLE
            column: NAME
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: ds1
        schema: ""
        table: CTE_1
        column: ""
      - server: ""
        database: ds1
        schema: ""
        table: CTE_2
        column: ""
      - server: ""
        database: ds1
        schema: ""
        table: address
        column: ""
      - server: ""
        database: ds1
        schema: ""
        table: people
        column: ""
    predicatecolumns: []
- description: Parenthesized join (ON+USING legacy over-accept; ADDRESS deliberately has NO ID column so the USING(ID) coalesce is one-sided — with an ADDRESS.ID the legacy resolver under-reports the explicit ID lineage to PEOPLE.ID only while omni correctly merges both sides; reshaped so both agree, mirroring the bigquery sibling)
  statement: SELECT ID, NAME, ADDRESS FROM (people JOIN address ON people.ID = address.PEOPLE_ID USING (ID));
  defaultDatabase: ds1
  metadata: |-
    {
      "name":  "ds1",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "PEOPLE",
              "columns":  [
                {
                  "name":  "ID"
                },
                {
                  "name":  "NAME"
                }
              ]
            },
            {
              "name":  "ADDRESS",
              "columns":  [
                {
                  "name":  "PEOPLE_ID"
                },
                {
                  "name":  "ADDRESS"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: ds1
            schema: ""
            table: PEOPLE
            column: ID
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: NAME
        sourcecolumns:
          - server: ""
            database: ds1
            schema: ""
            table: PEOPLE
            column: NAME
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: ADDRESS
        sourcecolumns:
          - server: ""
            database: ds1
            schema: ""
            table: ADDRESS
            column: ADDRESS
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: ds1
        schema: ""
        table: address
        column: ""
      - server: ""
        database: ds1
        schema: ""
        table: people
        column: ""
    predicatecolumns: []
- description: Join using (ON+USING legacy over-accept; ADDRESS deliberately has NO ID column — see the Parenthesized-join sibling note)
  statement: SELECT ID, NAME, ADDRESS FROM people JOIN address ON people.ID = address.PEOPLE_ID USING (ID);
  defaultDatabase: ds1
  metadata: |-
    {
      "name":  "ds1",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "PEOPLE",
              "columns":  [
                {
                  "name":  "ID"
                },
                {
                  "name":  "NAME"
                }
              ]
            },
            {
              "name":  "ADDRESS",
              "columns":  [
                {
                  "name":  "PEOPLE_ID"
                },
                {
                  "name":  "ADDRESS"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: ds1
            schema: ""
            table: PEOPLE
            column: ID
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: NAME
        sourcecolumns:
          - server: ""
            database: ds1
            schema: ""
            table: PEOPLE
            column: NAME
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: ADDRESS
        sourcecolumns:
          - server: ""
            database: ds1
            schema: ""
            table: ADDRESS
            column: ADDRESS
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: ds1
        schema: ""
        table: address
        column: ""
      - server: ""
        database: ds1
        schema: ""
        table: people
        column: ""
    predicatecolumns: []
- description: Simple join
  statement: SELECT ID, NAME, ADDRESS FROM people JOIN address ON people.ID = address.PEOPLE_ID;
  defaultDatabase: maskingdb
  metadata: |-
    {
      "name":  "maskingdb",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "People",
              "columns":  [
                {
                  "name":  "Id"
                },
                {
                  "name":  "Name"
                }
              ]
            },
            {
              "name":  "Address",
              "columns":  [
                {
                  "name":  "PeopleId"
                },
                {
                  "name":  "Address"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: People
            column: Id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: NAME
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: People
            column: Name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: ADDRESS
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Address
            column: Address
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: maskingdb
        schema: ""
        table: address
        column: ""
      - server: ""
        database: maskingdb
        schema: ""
        table: people
        column: ""
    predicatecolumns: []
- description: Recursive cte
  statement: |-
    WITH RECURSIVE CTE_01 AS (
      (SELECT a AS c1, b AS c2, c AS c3, 1 AS n FROM T1)
      UNION ALL
      SELECT c1 * c2, c2 + c1, c3 * c2, n + 1 FROM CTE_01 WHERE n < 5
    )
    SELECT * FROM CTE_01;
  defaultDatabase: maskingdb
  metadata: |-
    {
      "name":  "maskingdb",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T1",
              "columns":  [
                {
                  "name":  "a"
                },
                {
                  "name":  "b"
                },
                {
                  "name":  "c"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: C1
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: T1
            column: a
          - server: ""
            database: maskingdb
            schema: ""
            table: T1
            column: b
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: C2
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: T1
            column: a
          - server: ""
            database: maskingdb
            schema: ""
            table: T1
            column: b
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: C3
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: T1
            column: a
          - server: ""
            database: maskingdb
            schema: ""
            table: T1
            column: b
          - server: ""
            database: maskingdb
            schema: ""
            table: T1
            column: c
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: "N"
        sourcecolumns: []
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: maskingdb
        schema: ""
        table: CTE_01
        column: ""
      - server: ""
        database: maskingdb
        schema: ""
        table: T1
        column: ""
    predicatecolumns: []
- description: Simple normal cte
  statement: WITH CTE_1 AS (SELECT Id, Name FROM Customers) SELECT * FROM CTE_1;
  defaultDatabase: maskingdb
  metadata: |-
    {
      "name":  "maskingdb",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "Customers",
              "columns":  [
                {
                  "name":  "Id"
                },
                {
                  "name":  "Name"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: NAME
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: maskingdb
        schema: ""
        table: CTE_1
        column: ""
      - server: ""
        database: maskingdb
        schema: ""
        table: Customers
        column: ""
    predicatecolumns: []
- description: Correlated subquery in the target field clause.
  statement: SELECT city, (SELECT COUNT(*) FROM paintings p WHERE g.id = p.gallery_id) AS total_paintings FROM galleries g;
  defaultDatabase: ds1
  metadata: |-
    {
      "name":  "ds1",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "GALLERIES",
              "columns":  [
                {
                  "name":  "ID"
                },
                {
                  "name":  "CITY"
                }
              ]
            },
            {
              "name":  "PAINTINGS",
              "columns":  [
                {
                  "name":  "GALLERY_ID"
                },
                {
                  "name":  "ARTIST_ID"
                },
                {
                  "name":  "TITLE"
                },
                {
                  "name":  "PRICE"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: CITY
        sourcecolumns:
          - server: ""
            database: ds1
            schema: ""
            table: GALLERIES
            column: CITY
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: TOTAL_PAINTINGS
        sourcecolumns: []
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: ds1
        schema: ""
        table: galleries
        column: ""
      - server: ""
        database: ds1
        schema: ""
        table: paintings
        column: ""
    predicatecolumns: []
- description: FIXME(zp)Expression subquery
  statement: SELECT (SELECT Name FROM Customers), ID FROM Customers;
  defaultDatabase: maskingdb
  metadata: |-
    {
      "name":  "maskingdb",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "Customers",
              "columns":  [
                {
                  "name":  "Id"
                },
                {
                  "name":  "Name"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ""
        sourcecolumns: []
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: ID
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: maskingdb
        schema: ""
        table: Customers
        column: ""
    predicatecolumns: []
- description: Table subquery
  statement: WITH A AS (SELECT * FROM Customers) SELECT result.ID, * FROM (SELECT * FROM A) result;
  defaultDatabase: maskingdb
  metadata: |-
    {
      "name":  "maskingdb",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "Customers",
              "columns":  [
                {
                  "name":  "Id"
                },
                {
                  "name":  "Name"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: Id
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Id
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: Name
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Name
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: maskingdb
        schema: ""
        table: A
        column: ""
      - server: ""
        database: maskingdb
        schema: ""
        table: Customers
        column: ""
    predicatecolumns: []
- description: Wild projecter
  statement: SELECT s.* FROM Customers s;
  defaultDatabase: maskingdb
  metadata: |-
    {
      "name":  "maskingdb",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "Customers",
              "columns":  [
                {
                  "name":  "Id"
                },
                {
                  "name":  "Name"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: Id
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Id
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: Name
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Name
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: maskingdb
        schema: ""
        table: Customers
        column: ""
    predicatecolumns: []
- description: Simple projecter
  statement: SELECT Id, Name FROM Customers;
  defaultDatabase: maskingdb
  metadata: |-
    {
      "name":  "maskingdb",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "Customers",
              "columns":  [
                {
                  "name":  "Id"
                },
                {
                  "name":  "Name"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: NAME
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: maskingdb
        schema: ""
        table: Customers
        column: ""
    predicatecolumns: []
- description: Expression in target field
  statement: SELECT Id+1, Id+Name, foo(bar(Id), Name) FROM Customers;
  defaultDatabase: maskingdb
  metadata: |-
    {
      "name":  "maskingdb",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "Customers",
              "columns":  [
                {
                  "name":  "Id"
                },
                {
                  "name":  "Name"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: ID
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Id
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: ID
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Id
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: maskingdb
        schema: ""
        table: Customers
        column: ""
    predicatecolumns: []
- description: Simple select asterisk statement
  statement: SELECT * FROM Customers;
  defaultDatabase: maskingdb
  metadata: |-
    {
      "name":  "maskingdb",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "Customers",
              "columns":  [
                {
                  "name":  "Id"
                },
                {
                  "name":  "Name"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: Id
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Id
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: Name
        sourcecolumns:
          - server: ""
            database: maskingdb
            schema: ""
            table: Customers
            column: Name
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: maskingdb
        schema: ""
        table: Customers
        column: ""
    predicatecolumns: []
- description: Set op union all equal width explicit with sensitive column on second arm
  statement: SELECT id, name FROM users UNION ALL SELECT order_id, card_number FROM orders;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: order_id
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: NAME
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: card_number
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Set op union all three way with sensitive column on third arm
  statement: SELECT id FROM users UNION ALL SELECT order_id FROM orders UNION ALL SELECT iban FROM payments;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]},
            {"name": "payments", "columns": [{"name": "payment_id"}, {"name": "order_id"}, {"name": "paid_amount"}, {"name": "iban"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: order_id
          - server: ""
            database: spannerdb
            schema: ""
            table: payments
            column: iban
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: payments
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Set op union all with select star first arm
  statement: SELECT * FROM users UNION ALL SELECT order_id, user_id, amount, card_number FROM orders;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: id
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: order_id
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: name
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: user_id
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: email
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: amount
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: email
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: ssn
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: card_number
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: ssn
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Set op union distinct
  statement: SELECT name FROM users UNION DISTINCT SELECT card_number FROM orders;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: NAME
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: card_number
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Set op intersect distinct
  statement: SELECT email FROM users INTERSECT DISTINCT SELECT iban FROM payments;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "payments", "columns": [{"name": "payment_id"}, {"name": "order_id"}, {"name": "paid_amount"}, {"name": "iban"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: EMAIL
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: payments
            column: iban
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: email
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: payments
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Set op except distinct still taints from excluded arm
  statement: SELECT phone FROM profiles EXCEPT DISTINCT SELECT card_number FROM orders;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "profiles", "columns": [{"name": "id"}, {"name": "address"}, {"name": "phone"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: PHONE
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: card_number
          - server: ""
            database: spannerdb
            schema: ""
            table: profiles
            column: phone
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: profiles
        column: ""
    predicatecolumns: []
- description: Set op different arm names keeps first arm name
  statement: SELECT id AS user_key FROM users UNION ALL SELECT order_id AS order_key FROM orders;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: USER_KEY
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: order_id
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Set op of two subset projecting ctes
  statement: WITH safe_users AS (SELECT id, name FROM users), safe_orders AS (SELECT order_id, card_number FROM orders) SELECT * FROM safe_users UNION ALL SELECT * FROM safe_orders;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: order_id
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: NAME
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: card_number
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: safe_orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: safe_users
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Join on with sensitive columns unprojected
  statement: SELECT u.name, o.amount FROM users u JOIN orders o ON u.id = o.user_id;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: NAME
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: AMOUNT
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: amount
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Join using uppercase identifier coalesces
  statement: SELECT * FROM users JOIN logins USING (ID);
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "logins", "columns": [{"name": "id"}, {"name": "device"}, {"name": "ip_address"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: id
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: logins
            column: id
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: name
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: email
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: email
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: ssn
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: ssn
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: device
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: logins
            column: device
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: ip_address
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: logins
            column: ip_address
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: logins
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Self join with aliases
  statement: SELECT a.full_name, b.salary FROM employees a JOIN employees b ON a.manager_id = b.emp_id;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "employees", "columns": [{"name": "emp_id"}, {"name": "manager_id"}, {"name": "full_name"}, {"name": "salary"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: FULL_NAME
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: employees
            column: full_name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: SALARY
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: employees
            column: salary
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: employees
        column: ""
    predicatecolumns: []
- description: Three table join chain
  statement: SELECT u.name, o.amount, p.iban FROM users u JOIN orders o ON u.id = o.user_id JOIN payments p ON o.order_id = p.order_id;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]},
            {"name": "payments", "columns": [{"name": "payment_id"}, {"name": "order_id"}, {"name": "paid_amount"}, {"name": "iban"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: NAME
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: AMOUNT
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: amount
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: IBAN
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: payments
            column: iban
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: payments
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Select star over join
  statement: SELECT * FROM users u JOIN orders o ON u.id = o.user_id;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: id
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: name
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: email
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: email
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: ssn
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: ssn
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: order_id
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: order_id
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: user_id
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: user_id
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: amount
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: amount
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: card_number
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: card_number
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Left join with sensitive column on right side
  statement: SELECT u.name, o.card_number FROM users u LEFT JOIN orders o ON u.id = o.user_id;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: NAME
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: CARD_NUMBER
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: card_number
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Comma cross join
  statement: SELECT u.name, l.device FROM users u, logins l;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "logins", "columns": [{"name": "id"}, {"name": "device"}, {"name": "ip_address"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: NAME
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: DEVICE
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: logins
            column: device
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: logins
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Subset projecting cte then select star over it
  statement: WITH safe AS (SELECT id, name FROM users) SELECT * FROM safe;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: NAME
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: safe
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Recursive cte with join back to cte
  statement: |-
    WITH RECURSIVE ladder AS (
      SELECT emp_id, manager_id, full_name FROM employees
      UNION ALL
      SELECT e.emp_id, e.manager_id, e.full_name FROM employees e JOIN ladder l ON e.manager_id = l.emp_id
    )
    SELECT full_name FROM ladder;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "employees", "columns": [{"name": "emp_id"}, {"name": "manager_id"}, {"name": "full_name"}, {"name": "salary"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: FULL_NAME
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: employees
            column: full_name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: employees
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: ladder
        column: ""
    predicatecolumns: []
- description: Nested cte inside cte body
  statement: WITH outer_cte AS (WITH inner_cte AS (SELECT id, email FROM users) SELECT id FROM inner_cte) SELECT * FROM outer_cte;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: inner_cte
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: outer_cte
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Cte referenced twice with different aliases
  statement: WITH c AS (SELECT id, name, ssn FROM users) SELECT a.id, b.name FROM c a JOIN c b ON a.id = b.id;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: NAME
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: c
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Star over join of cte and base table
  statement: WITH safe AS (SELECT id, name FROM users) SELECT * FROM safe s JOIN orders o ON s.id = o.user_id;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: NAME
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: order_id
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: order_id
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: user_id
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: user_id
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: amount
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: amount
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: card_number
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: card_number
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: safe
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Derived table select star with subset projection
  statement: SELECT * FROM (SELECT id, name FROM users) d;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: NAME
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Derived table renamed projection referenced by alias
  statement: SELECT d.alias_col FROM (SELECT email AS alias_col FROM users) d;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ALIAS_COL
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: email
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Derived table computed projection referenced by alias
  statement: SELECT d.total FROM (SELECT amount + 1 AS total FROM orders) d;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: TOTAL
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: amount
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
    predicatecolumns: []
- description: Derived table dot star
  statement: SELECT d.* FROM (SELECT id, ssn FROM users) d;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ID
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: SSN
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: ssn
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Unaliased scalar subquery in select list
  statement: SELECT (SELECT email FROM users), id FROM users;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ""
        sourcecolumns: []
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: ID
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Aliased correlated scalar subquery projecting sensitive column
  statement: SELECT o.order_id, (SELECT u.ssn FROM users u WHERE u.id = o.user_id) AS owner_ssn FROM orders o;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ORDER_ID
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: order_id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: OWNER_SSN
        sourcecolumns: []
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Struct field path with table alias prefix
  statement: SELECT p.address.city FROM profiles p;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "profiles", "columns": [{"name": "id"}, {"name": "address"}, {"name": "phone"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ADDRESS
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: profiles
            column: address
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: profiles
        column: ""
    predicatecolumns: []
- description: Struct field path without table prefix
  statement: SELECT address.city FROM profiles;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "profiles", "columns": [{"name": "id"}, {"name": "address"}, {"name": "phone"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: ADDRESS
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: profiles
            column: address
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: profiles
        column: ""
    predicatecolumns: []
- description: Table name qualified star over join
  statement: SELECT users.* FROM users JOIN orders ON users.id = orders.user_id;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: id
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: name
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: email
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: email
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: ssn
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: ssn
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Named schema table joined with default schema table of same name
  statement: SELECT a.region, b.email FROM analytics.users a JOIN users b ON a.id = b.id;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]}
          ]
        },
        {
          "name": "analytics",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "region"}, {"name": "score"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: REGION
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: analytics
            table: users
            column: region
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: EMAIL
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: email
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: analytics
        table: users
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []
- description: Select star from named schema table
  statement: SELECT * FROM analytics.events;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]}
          ]
        },
        {
          "name": "analytics",
          "tables": [
            {"name": "events", "columns": [{"name": "event_id"}, {"name": "user_id"}, {"name": "payload"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: event_id
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: analytics
            table: events
            column: event_id
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: user_id
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: analytics
            table: events
            column: user_id
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: payload
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: analytics
            table: events
            column: payload
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: analytics
        table: events
        column: ""
    predicatecolumns: []
- description: Three part database schema table name
  statement: SELECT event_id FROM spannerdb.analytics.events;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]}
          ]
        },
        {
          "name": "analytics",
          "tables": [
            {"name": "events", "columns": [{"name": "event_id"}, {"name": "user_id"}, {"name": "payload"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: EVENT_ID
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: analytics
            table: events
            column: event_id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: analytics
        table: events
        column: ""
    predicatecolumns: []
- description: Table name qualified column over named schema table
  statement: SELECT events.payload FROM analytics.events;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]}
          ]
        },
        {
          "name": "analytics",
          "tables": [
            {"name": "events", "columns": [{"name": "event_id"}, {"name": "user_id"}, {"name": "payload"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: PAYLOAD
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: analytics
            table: events
            column: payload
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: analytics
        table: events
        column: ""
    predicatecolumns: []
- description: Information schema select is system only
  statement: SELECT table_name FROM INFORMATION_SCHEMA.TABLES;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb"
    }
  querySpan:
    type: 3
    results: []
    sourcecolumns: []
    predicatecolumns: []
- description: Lowercase information schema select is system only
  statement: SELECT t.table_name FROM information_schema.tables t;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb"
    }
  querySpan:
    type: 3
    results: []
    sourcecolumns: []
    predicatecolumns: []
- description: Spanner sys select is system only
  statement: SELECT * FROM SPANNER_SYS.QUERY_STATS_TOP_MINUTE;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb"
    }
  querySpan:
    type: 3
    results: []
    sourcecolumns: []
    predicatecolumns: []
- description: Star except over join with sensitive columns excluded
  statement: SELECT * EXCEPT (ssn, card_number) FROM users u JOIN orders o ON u.id = o.user_id;
  defaultDatabase: spannerdb
  metadata: |-
    {
      "name": "spannerdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {"name": "users", "columns": [{"name": "id"}, {"name": "name"}, {"name": "email"}, {"name": "ssn"}]},
            {"name": "orders", "columns": [{"name": "order_id"}, {"name": "user_id"}, {"name": "amount"}, {"name": "card_number"}]}
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
      - name: id
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: id
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: name
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: name
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: email
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: users
            column: email
        isplainfield: false
        sourcefieldpaths: []
        selectasterisk: false
      - name: order_id
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: order_id
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: user_id
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: user_id
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
      - name: amount
        sourcecolumns:
          - server: ""
            database: spannerdb
            schema: ""
            table: orders
            column: amount
        isplainfield: true
        sourcefieldpaths: []
        selectasterisk: false
    sourcecolumns:
      - server: ""
        database: spannerdb
        schema: ""
        table: orders
        column: ""
      - server: ""
        database: spannerdb
        schema: ""
        table: users
        column: ""
    predicatecolumns: []