translate_sql(x %like% "ab*")
#> <SQL> "x" LIKE 'ab*'

library(RSQLite)
library(nycflights13)
dat <- nycflights13_sqlite() %>% tbl("flights")
dat %>% filter(dest == 'IAH') %>% tally() # returns 7198 rows
dat %>% filter(dest %like% "IA*") %>% tally() # returns 0 rows