We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
is it possible to use str_glue and have a WHERE clause on a list?
str_glue
For example if my_list = c('apple', 'pear'), how can i write the clause using str_glue("select * from my_table where fruit in {my_list};")
my_list = c('apple', 'pear')
str_glue("select * from my_table where fruit in {my_list};")
without having to create the concatenated string myself with my_list_str <- paste0("'", my_list, "'", collapse = ", ")?
my_list_str <- paste0("'", my_list, "'", collapse = ", ")
Would it be possible to have the same syntax as there is in glue::glue_sql? ie using ({my_list*})?
({my_list*})
The text was updated successfully, but these errors were encountered:
No branches or pull requests
is it possible to use
str_glueand have a WHERE clause on a list?For example if
my_list = c('apple', 'pear'),how can i write the clause using
str_glue("select * from my_table where fruit in {my_list};")without having to create the concatenated string myself with
my_list_str <- paste0("'", my_list, "'", collapse = ", ")?Would it be possible to have the same syntax as there is in glue::glue_sql? ie using
({my_list*})?The text was updated successfully, but these errors were encountered: