In WinVector/rquery: Relational Query Generator for Data Manipulation at Scale

rquery 0.4.2 now includes tests that report which DBI methods appear to be correclty implemented for a given database connection. rquery also supplies a number of work-around methods that use these determinations.

Here are the tests on a few popular database connections.

`RSQLite`

db <- DBI::dbConnect(RSQLite::SQLite(), 
                     ":memory:")

rquery::rq_connection_tests(db)

DBI::dbDisconnect(db)

`RPostgreSQL`

db <- DBI::dbConnect(RPostgreSQL::PostgreSQL(),
                     host = 'localhost',
                     port = 5432,
                     user = 'johnmount',
                     password = '')

rquery::rq_connection_tests(db)

DBI::dbDisconnect(db)

`RPostgres`

db <- DBI::dbConnect(RPostgres::Postgres(),
                     host = 'localhost',
                     port = 5432,
                     user = 'johnmount',
                     password = '')

rquery::rq_connection_tests(db)

DBI::dbDisconnect(db)

`sparklyr`

db <- sparklyr::spark_connect(version='2.2.0', 
                              master = "local")

rquery::rq_connection_tests(db)

sparklyr::spark_disconnect(db)