Is multiple search possible in ydn-db?

Question

I want to do following queries,

1) Multi query like

SELECT * FROM table_name WHERE username="Tom" OR lastname="Gordon" OR city="New York"; 

2) Combination of AND and OR operations. Ex:

SELECT * FROM table_name WHERE username="Tom" OR lastname="Gordon" AND age=25;

Answer 1

Multiple AND is possible using SortedMerge or ZigZagMerge. See here for documentation and here for example.

Use db.scan for OR query.

These two types of query can be combine as long as OR is top of the node, i.e, disjunctive normal form.

Unfortunately these query are not available yet in fluent Query API, so terrible to use now.