Yes I think a dialect or datastoreprovider should expose it's tx / non-tx nature and based on that we can skip auto-flush or not.