Function-ify SQL queries

[jordantgh]

Rewrite the query logic to take columns as arguments, etc.

[jordantgh]

@dianario This is also something you could take a look at if you want to learn a bit of SQL. It should be fairly simple.

Instead of writing

function() {
  dbGetQuery(db, "
  SELECT col1, col2, col3 FROM table;
  ")
}

We can isntead do

function(colnames_vector) {
  dbGetQuery(db, glue::glue("
  SELECT {colnames_vector} FROM table;
  "))
}

This will help make the code easier to change and more transparent in the future, as we can pass in the columns within the pipeline script.

Note this refers to code/process_tables/queries.r

[dianario]

Does this still need to get done?

[jordantgh]

Does this still need to get done?

It is something simple to implement if you want to get your feet wet.