SQLite Forum

Are Views just stored SQL Strings or something more?
Login
I have been using MS Access for eons and have wanted to convert my applications to Sqlite. Aside from the obvious missing forms and reports (which are starting to be addressed with MD and other changes), Sqlite doesn't have saved queries, except --- wait for it --- something called a view! A view is a very simple, one-table query.

Is is a big step to provide the ability to add WHERE and ORDER BY to the view definition? And then the real bonus: add JOIN capability? With those things, you suddenly get a viable saved-query system, I think, at very little additional cost. And what about parameterized queries? Is that too big a step?