We test it implicitly with integration tests across the API for the most part. We occasionally have unit tests (in C#) that directly call stored procs.
The backbone for this is that we spin up a DB per unit test, so we don't have to worry about shared state.