TPC-H queries

[ajnavarro]

TPC-H is a set of queries to benchmark decision support on databases. The queries are business oriented.

This issue is an umbrella issue to group all the bugs that we need to fix to be able to run this set of queries.

Bugs

• CROSS JOIN doesn't support more than 2 tables #38 Support more than two tables on JOINS
• Unsupported syntax: &sqlparser.AndExpr{Left:(*sqlparser.AndExpr)(0xc42899c480), Right:(*sqlparser.ComparisonExpr)(0xc4289c4340)} #40 Unsupported syntax that should be supported
• unsupported feature: not regexp #58 NOT REGEXP

Missing features

• Fix unsupported feature: non simple tables #46 Aliased tables
• Implement DATE data type #45 DATE type
• Implement YEAR(date) Function #43 YEAR(date) function
• Implement SUBSTRING(string, start, length) function #42 SUBSTRING function
• Unsupported syntax: sqlparser.ParenExpr #41 Implement ParentExpr syntax
• TPC-H: unsupported feature: HAVING #56 HAVING
• TPC-H: Implement Inner Join #57 INNER JOIN
• Support sqlparser.Subquery statement #59 SUBQUERY
• Add support to sqlparser.ValTuple and sqlparser.SQLVal #60 List of values
• Implement avg() Function #61 AVG() function
• BETWEEN Expresion #62 Between

This issue will be updated with new needed features and bugs.