TPC-H Query 21

[alamb]

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

Fails with error:

Compound identifier not supported: "Unsupported compound identifier '["l1", "l_suppkey"]

[alamb]

Comment from Mike Seddon(MikeSeddonAU) @ 2021-02-08T21:20:20.128+0000:

This has been added in https://github.com/apache/arrow/pull/9243 but will require a change like:

substring(c_phone from 1 for 2) 
to
substr(c_phone, 1, 2)

Comment from Daniël Heres(Dandandan) @ 2021-02-08T21:29:24.069+0000:

Very good [~MikeSeddonAU]! I plan to release sqlparser with support for parsing the syntax here: https://github.com/ballista-compute/sqlparser-rs/pull/293 and upgrading DataFusion to use a newer version

Comment from Mike Seddon(MikeSeddonAU) @ 2021-02-08T21:35:38.374+0000:

Great. I will need to get my head around the sqlparser so the rest of the strange ANSI syntax can be implemented like this: 

overlay('Txxxxas' placing 'hom' from 2 for 4)

[Dandandan]

Duplicate #172