Do DBs used for android apps cache in memory?

Normally when using an SQL database (MySQL, MS-SQL etc) the database caches as much as possible in memory for performance.
When using a database for an android app e.g sqlite does it also uses the same/similar approach to caching? Does it cache as much as possible in memory or for the android environment does it go to SD for each query?