Skip to content

Subquery support for DLC statement #84

@takegue

Description

@takegue

https://cloud.google.com/bigquery/docs/managing-row-level-security#create_or_update_a_row-level_access_policy

CREATE OR REPLACE ROW ACCESS POLICY apac_filter
ON project.dataset.my_table
GRANT TO ('domain:example.com')
FILTER USING (region IN (
    SELECT
      region
    FROM
      lookup_table
    WHERE
      email = SESSION_USER()));

Current parse result:

[source_file](https://takegue.github.io/tree-sitter-sql-bigquery/#) [0, 0] - [10, 0]
  [ERROR](https://takegue.github.io/tree-sitter-sql-bigquery/#) [0, 0] - [3, 23]
    [keyword_replace](https://takegue.github.io/tree-sitter-sql-bigquery/#) [0, 7] - [0, 17]
  [query_statement](https://takegue.github.io/tree-sitter-sql-bigquery/#) [3, 24] - [9, 29]
    [query_expr](https://takegue.github.io/tree-sitter-sql-bigquery/#) [3, 24] - [9, 29]
      [query_expr](https://takegue.github.io/tree-sitter-sql-bigquery/#) [4, 4] - [9, 28]
        [select](https://takegue.github.io/tree-sitter-sql-bigquery/#) [4, 4] - [9, 28]
          [select_list](https://takegue.github.io/tree-sitter-sql-bigquery/#) [5, 6] - [5, 12]
            [select_expression](https://takegue.github.io/tree-sitter-sql-bigquery/#) [5, 6] - [5, 12]
              [identifier](https://takegue.github.io/tree-sitter-sql-bigquery/#) [5, 6] - [5, 12]
          [from_clause](https://takegue.github.io/tree-sitter-sql-bigquery/#) [6, 4] - [7, 18]
            [from_item](https://takegue.github.io/tree-sitter-sql-bigquery/#) [7, 6] - [7, 18]
              table_name: [identifier](https://takegue.github.io/tree-sitter-sql-bigquery/#) [7, 6] - [7, 18]
          [where_clause](https://takegue.github.io/tree-sitter-sql-bigquery/#) [8, 4] - [9, 28]
            [binary_expression](https://takegue.github.io/tree-sitter-sql-bigquery/#) [9, 6] - [9, 28]
              left: [identifier](https://takegue.github.io/tree-sitter-sql-bigquery/#) [9, 6] - [9, 11]
              right: [function_call](https://takegue.github.io/tree-sitter-sql-bigquery/#) [9, 14] - [9, 28]
                function: [identifier](https://takegue.github.io/tree-sitter-sql-bigquery/#) [9, 14] - [9, 26]
  [ERROR](https://takegue.github.io/tree-sitter-sql-bigquery/#) [9, 29] - [9, 30]

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions