Epicor’s recommendation has always been, do not hit the database directly - use the framework. (Bart was the Epicor Architect at the time of this post.)
There are two timing issues. Caching and deferred write tables. Both are intended to improve performance.
What problem are you trying to solve that requires direct access?