Features for Self Driving Benchmark

List the features that we need to support to run the self-driving benchmarks:

• DROP SCHEMA IF EXISTS
• DEFAULT null, DEFAULT NOW(), DEFAULT nextval()
• ENUM
• UDF
• TRIGGERS
• CREATE SEQUENCE
• DATATYPE - SERIAL
• What-If API of the optimizer

List of SQL functions that are better to have:

More important:

• NOW()
• EXTRACT() (siva and priyatham)
• LIKE (done)
• LOWER
• DATE_TRUNC (done)
• TRIM (done)
• CONCAT
• CAST( AS CHAR), :: in Postgres (who knows what's the status on this?)
• CURRENT_DATE

Less important:

• ABS (pervaze)
• CEILING (done)
• LENGTH (done)
• NULLIF
• GROUP_CONCAT
• ROUND (done)
• FLOOR (done)
• BETWEEN
• COALESCE
• UPPER