Add feature: multiple (?) or order_by() in query condition

1 files changed, 16 insertions, 0 deletions

diff --git a/feature/view/list b/feature/view/list
index aa02062..2bd4bc8 100644
--- a/feature/view/list
+++ b/feature/view/list
@@ -1,3 +1,19 @@
+- Multiple (?) or order_by() in query condition
+
+  Consider:
+
+  #pragma ... query(foo.bar.not_null () && (?))
+
+  If we substitute "ORDER BY ..." for (?), then we will get "... AND ORDER BY"
+  in the statement. We can make it work by changing && to + but then if
+  we actually have additional conditions, that won't work.
+
+  One idea: have order_by() pragma? Though we can also have LIMIT, OFFSET,
+  etc. This should also align with ORDER BY, etc syntax in general queries.
+
+  Another idea: support multiple (?) that are "filled" from multiple
+  query() arguments (C++11 variadic template).
+
 - Member names for table views
 
   Currently we have to specify column names as strings in table views queries.