Port sql tests written in Rust to sqllogictests

[mvanschellebeeck]

Describe the solution you'd like
Port tests from datafusion/core/tests/sql to sqllogictests

[mvanschellebeeck]

@xudong963, @alamb - as a follow up should we also remove the ported test from the .rs files?

[xudong963]

@xudong963, @alamb - as a follow up should we also remove the ported test from the .rs files?

Yes, I think it's nice to remove!

[alamb]

Yes, I think it's nice to remove!

I agree. Thank you

I also suspect that as we try to port more we will find other gaps (e.g. the lack of support for INSERT and normalization), and I hope to use those gaps as a way to drive adding new features to the sqllogic framework (either in DataFusion or contributing back upstream)

[alamb]

BTW I plan to port more of the tests in information_schema to the sqllogic framework. One thing I will need to do is to support "expected errors"