macaw.core — io.github.metabase/macaw 0.2.16

parsed-query clj

(parsed-query query & {:as opts})

Main entry point: takes a string query and returns a Statement object that can be handled by the other functions.

query->components clj

(query->components statement & {:as opts})

Given a parsed query (i.e., a [subclass of] Statement) return a map with the elements found within it.

(Specifically, it returns their fully-qualified names as strings, where 'fully-qualified' means 'as referred to in the query'; this function doesn't do additional inference work to find out a table's schema.)

query->tables clj

(query->tables sql & {:keys [mode] :as opts})

Given a parsed query (i.e., a [subclass of] Statement) return a set of all the table identifiers found within it.

replace-names clj

(replace-names sql renames & {:as opts})

Given an SQL query, apply the given table, column, and schema renames.

Supported options:

• case-insensitive: whether to relax the comparison

  • :upper - identifiers are implicitly case to uppercase, as per the SQL-92 standard.
  • :lower - identifiers are implicitly cast to lowercase, as per Postgres et al.
  • :agnostic - case is ignored when comparing identifiers in code to replacement "from" strings.

• quotes-preserve-case: whether quoted identifiers should override the previous option.

scope-id clj

(scope-id s)

A unique identifier for the given scope.

scope-label clj

(scope-label s)

The type of scope we're talking about e.g., a top-level SELECT.