Referenced From: https://github.com/AlaSQL/alasql/wiki
Syntax:
expression IN array
AlaSQL supports IN
operation:
SELECT path FROM obsidian_markdown_notes WHERE 'project' IN tags
SELECT a FROM one WHERE b IN (1,2,3)
SELECT a FROM one WHERE b IN (SELECT b FROM two)
SELECT a FROM one WHERE b IN ?
In the expression
expression IN @(expression)
like:
SELECT path FROM obsidian_markdown_notes WHERE frontmatter->area IN @('area1','area2')
10 IN @(?)
@a IN @(@b)
20 IN @(@[10,20,30])