query_db: Query the database with user-defined query string

In lmullany/pmap_utilities: API to PMAP Projections

Query the database with user-defined query string

Description

This function allows a query on the database, using a string. Is equivalent to tbl(con,sql(query)) or dbGetQuery(con,query)

Usage

query_db(query, engine = default_engine)

Arguments

query	a user-defined query string
engine	a dbConnect connection object

Value

a (lazy) dplyr::tbl / data frame object with results

Examples

query_db("SELECT COUNT(*) AS CT FROM MYSCHEMA.MYTABLE", myconnection)

lmullany/pmap_utilities documentation built on July 30, 2023, 8:54 a.m.