It depends. A couple databases have a default isolation level that allow dirty reads. Most SQL databases allow you to manually change the isolation level or ReadConcern level to allow Uncommitted Reads if you choose.