[R] From within R, what are "good" ways to run SQL code contained in a text file?

[Kelly Thompson]

I am interested in this topic and found this post on StackOverflow,
https://stackoverflow.com/questions/44853322/how-to-read-the-contents-of-an-sql-file-into-an-r-script-to-run-a-query

This response seems especially useful,
https://stackoverflow.com/a/44886192/10816734

I'm curious about the thoughts and insights people here in r-help have
about this question and topic, and to learn if there are "better" ways
than what is suggested in the StackOverflow thread.

Thank you!