read_sql() function - Githubissues

OuhscBbmc / OuhscMunge

Data manipulation operations

http://ouhscbbmc.github.io/OuhscMunge/

Other

1 stars 4 forks source link

Closed wibeasley closed 6 years ago

wibeasley commented 6 years ago

Create a function that allows the caller to

[x] execute a SELECT SQL statement over RODBC/odbc
[x] sets stringsAsFactors=F
[x] uses verify_data_frame() so the SQL error message isn't confused with a data.frame/tibble
[x] returns tibble
[ ] (optional): allows user to specify column types.

wibeasley commented 6 years ago

The execute_sql_file() could easily accommodate everything here except the user-specified columns