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])