Collection of 'SQL' Utilities for 'T-SQL' and 'Postgresql'
Call a SQL function/procedure.
Connect to a database using a connection string via DBI/odbc.
Generate a CREATE TABLE statement based on a data.frame, optionally ex...
Generate a DROP TABLE statement, optionally execute the statement if c...
Retrieve the columns/types in a table.
Retrieve the definition of a function/procedure.
Retrieve the output parameters of a function/procedure.
Retrieve the input parameters of a function/procedure.
Retrieve the tables in a schema
Helper function for INSERT
Generate a INSERT statement, optionally execute the statement if con i...
Add single quotes to strings using stringi::stri_join, useful for conv...
Convert a column name into a SQL compatible name.
Get the equivalent SQL data type for a given R object.
Generate a BULK INSERT statement, optionally execute the statement if ...
Generate a CREATE TABLE statement for an existing table in Microsoft S...
Fetch the object definition of a proc in Microsoft SQL Server.
Generate a TRUNCATE TABLE statement, optionally execute the statement ...
Generate a UPDATE statement, optionally execute the statement if con i...
Includes functions for interacting with common meta data fields, writing insert statements, calling functions, and more for 'T-SQL' and 'Postgresql'.