R/as_sql_array.R

In quartin/dbutils: A set of utility functions for dealing with databases in R

#' @export
#' @title Transform a vector into a SQL-interpreted array.
#'
#' @param vector character vector
#' @return
#'   List with a single string that's interpreted as a SQL array to interpolate in a query.
as_sql_array <- function(vector) {
  array <- paste0("(", paste(paste0("'", vector, "'"), collapse = ", "), ")")
  list(array)
}