customQuery: Custom SQL Query on existing connection

In gogonzo/oddsandsods: Miscellanous functions

Description

Custom SQL Query on existing connection

Usage

customQuery(query, ..., return_query = F)

Arguments

query	SQL query to be processed
...	arguments passed to query
return_query	if TRUE function returns only character element with custom query

Examples

customQuery({"
  select *
  from mytable
  where id in (%s)"}, quoted(1:10), return_query=T)
customQuery({"
  select *
  from mytable
  where id in (%s)"}, quoted(1:10, collapse=","), return_query=T)

gogonzo/oddsandsods documentation built on May 12, 2019, 1:35 a.m.