A modern programming language that makes developers happier.

kotlinlang

Does using `@DatabaseView` take up additional space in app memory (not storage)? Does it generate a temporary in-memory table of the view fields, or does it perform the `SELECT` query each time you access the view?

it translates to a <https://www.sqlite.org/lang_createview.html|SQLite view>, which is equivalent to a `SELECT` query run every time. note that queries on a view, like queries with subqueries, might require temporarily materializing the view/subquery depending on the SQLite optimizer. <https://www.sqlite.org/tempfiles.html#materializations_of_views_and_subqueries>