How are postgres transactions supported in prefect sqlalchemy?

[wakatara]

I am familiar with using SessionMaker with sqlalchemy for using rollback transactions in postgres, but it's a little unclear to me how to get this working with prefect sqlalchemy.

Expectation / Proposal

Prefect-sqlalchemy supports atomic transactions to allow rollback if any particular inserts fail. In particular, I want to insert images, calibrations, and photometry and have the entire thing rollback if any single one of those fail.

Traceback / Example

• I would like to help contribute a pull request to resolve this!
  (am totally willing to update or otherwise help with documentation to get this working.