Run a custom SQL query

Run a custom SQL query

am_custom_query(sql_query, con, ...)

Arguments

sql_query

the query

con

the connection to use, if missing an sqlite con is used

...

other arguments to be passed to the sql() fcn

See also

Other admin: am_db_duckdb(), am_db_sqlite(), am_use_offline_db(), con_am(), db_disco(), db_minify(), db_minify_path(), db_sync(), default_db(), http_ping()

Examples

if (FALSE) { # \dontrun{
am_custom_query("select * from speciesoccursum_r", con = con_am("extdata"))
} # }