Unfortunately, this is an ongoing Issue with DBI and RSQlite: https://github.com/r-dbi/RSQLite/issues/313
For now you probably should use your workaround.
Execute multiple SQL statements (read from file) in R using DBI and RSQLite
Unfortunately, this is an ongoing Issue with DBI and RSQlite: https://github.com/r-dbi/RSQLite/issues/313
For now you probably should use your workaround.