TPC-H Query 16

[alamb]

Note: migrated from original JIRA: https://issues.apache.org/jira/browse/ARROW-11529

IN (Subquery) in (WHERE) expression support is missing.

{{Error: NotImplemented("Unsupported ast node InSubquery { expr: Identifier(Ident { value: "ps_suppkey", quote_style: None }), subquery: Query { with: None, body: Select(Select { distinct: false, top: None, projection: [UnnamedExpr(Identifier(Ident { value: "s_suppkey", quote_style: None }))], from: [TableWithJoins { relation: Table { name: ObjectName([Ident { value: "supplier", quote_style: None }]), alias: None, args: [], with_hints: [] }, joins: [] }], selection: Some(BinaryOp { left: Identifier(Ident { value: "s_comment", quote_style: None }), op: Like, right: Value(SingleQuotedString("%Customer%Complaints%")) }), group_by: [], having: None }), order_by: [], limit: None, offset: None, fetch: None }, negated: true } in sqltorel")}}

[andygrove]

Fixed by #2421