Thanks! Facata is really a low-level API, so the only SQL that's sent is what's explicitly sent. That means it wouldn't have a 'with' for transactions because that would require SQL to be sent 'behind the scenes'.

Thanks for pointing me in the direction of psycopg2.sql, it looks interesting and I'll give it some thought.