Skip to contents

Get SQL query

Usage

# S3 method for chMDB
get_query(x, query, autoalias = !is_current_chMDB(x), ...)

# S3 method for chTKCat
get_query(x, query, ...)

get_query(x, query, ...)

Arguments

x

an object with a database connection

query

the SQL query

autoalias

Change this parameter only if you know what you're doing. if TRUE, make relevant alias to query the chMDB using the table names from the data model. If FALSE, the user must know the table instance name in the remote database. By default, autoalias is set to TRUE when using a non-current instance of the database.

...

method specific parameters

Value

A tibble with query results