Look up common SQL chunks from YAML definitions to be reused in SQL queries

Source: R/chunks.R

For more details and examples, please see the package README.md.

sql_chunk(key, ..., indent_after_linebreak = 0)

Arguments

key

optional key defined in sql_chunk_files to filter for
...

passed to glue for string interpolation
indent_after_linebreak

integer for extra indent

Value

string

Examples

if (FALSE) {
sql_chunk_files(system.file('example_sql_chunks.yaml', package = 'dbr'))
sql_chunk('dbr.shinydemo.countries.count')

## pass it right away to a database
countries <- db_query(sql_chunk('dbr.shinydemo.countries.count'), 'shinydemo')

## example for a more complex query
cities <- db_query(sql_chunk('dbr.shinydemo.cities.europe'), 'shinydemo')
}