These functions generate S3 objects that have been designed to simulate the action of a database connection, without actually having the database available. Obviously, this simulation can only be incomplete, but most importantly it allows us to simulate SQL generation for any database without actually connecting to it.

simulate_dbi(class = character())

simulate_access()

simulate_hive()

simulate_mysql()

simulate_impala()

simulate_mssql()

simulate_odbc()

simulate_oracle()

simulate_postgres()

simulate_sqlite()

simulate_teradata()

Details

Simulated SQL always quotes identifies with `x`, and strings with 'x'.