More debugging, and I believe I found the offending query:
It turns out that the query WAS in fact using logging, but was incorrectly disabled behind the flag --profile-all-database-queries which is default false to avoid time consuming log operations inside the backup flow.
I will merge the new query and get a canary out that has the fix so we can test if it works as expected.