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 str_detect().
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.