dbQuoteLiteral-TrinoConnection-method: Quote R values as Trino literals

In RTrino: 'DBI' Backend for 'Trino'

Quote R values as Trino literals

Description

Turns R values into SQL literals Trino accepts where a value of the matching type is expected. Used by DBI::sqlInterpolate() and glue::glue_sql(), and so the way to put values into a statement, since RTrino has no parameter binding. Missing values become NULL.

Usage

## S4 method for signature 'TrinoConnection'
dbQuoteLiteral(conn, x, ...)

Arguments

conn	A TrinoConnection object.
x	A vector to quote.
...	Unused, for compatibility with the generic.

Details

• character and factor: 'text', with embedded quotes doubled;

• logical: TRUE or FALSE;

• integer and integer64: the integer's digits;

• double: a DOUBLE literal that reads back as the same double, such as 0.30000000000000004E0, or nan(), infinity() or -infinity();

• Date: ⁠DATE '2026-01-15'⁠;

• POSIXct: ⁠TIMESTAMP '2026-01-15 10:30:00.123456'⁠, the instant as a wall-clock time in the connection's session.timezone, which is how Trino reads it back;

• a list of raw vectors: ⁠X'0102FF'⁠.

Other classes are quoted by DBI's default method.

Value

A DBI::SQL object.

Examples

con <- DBI::dbConnect(RTrino::Trino(), host = Sys.getenv("RTRINO_TEST_URL"),
                      catalog = "tpch", schema = "tiny")
DBI::dbQuoteLiteral(con, as.Date("2026-01-15"))
DBI::sqlInterpolate(
  con, "SELECT * FROM orders WHERE orderdate >= ?since AND urgent = ?flag",
  since = as.Date("2026-01-01"), flag = TRUE
)
DBI::dbDisconnect(con)

RTrino documentation built on Oct. 15, 2026, 5:08 p.m.