Skip to contents

SQL dialect for Trino

Source: R/dbplyr-dialect.R
sql_dialect.TrinoConnection.Rd

Describes Trino to dbplyr so that dplyr verbs on a TrinoConnection are translated to SQL Trino accepts. Registered, when dbplyr 2.6.0 or later is loaded, as an S3 method for dbplyr::sql_dialect(), the extension point that version introduced, which separates the SQL dialect from the connection mechanism.

Usage

sql_dialect.TrinoConnection(con)

Arguments

con

A TrinoConnection object.

Value

A dbplyr SQL dialect object.

Details

Trino quotes identifiers with double quotes (the SQL standard), supports the WINDOW clause, accepts AS before a table alias, and does not allow table.* prefixes on a star selection.