I like the database queries using the
dplyr syntax, but the translation is not all implemented for all the verbs.
For example: based on Database Queries With R
flights_db %>% filter(str_detect(tailnum, "^N[0-9][A-Z]")) %>% select(year:day, dep_delay, arr_delay) Error: str_detect() is not available in this SQL variant
Is it possible to insert in this
dplyr chain an SQL string? In this case to solve for the
Note: I am aware of the
glue_sql(), previously I was using this option, but lately I started to use the
dplyr for writing queries.