For PostgreSQL proper at least, Repo.query (and friends) should work fine.
I pass in some fairly gigantic DO blocks which include PostgreSQL single line comments, multi-line comments, “dollar-sign quoting”, nested dollar-sign quoting, etc. into individual Repo.query calls and I’ve had no issues.
I would expect that anything “within reason” in this regard shouldn’t cause problems.
