I usually wrap everything (including reads) in a transaction at middleware level. Not perfect, has its downsides but for many projects it's perfectly ok.

Of course it's not a real substitute for foreign keys, but definitely better than nothing.