Add sqllogictests for DataFusion `INSERT INTO`

[CTTY]

Is your feature request related to a problem or challenge?

As we are close to support INSERT INTO for both partitioned/unpartitioned data (#1827 ). It makes sense to start adding sqllogictests to validate the reading/writing behavior overall

Describe the solution you'd like

For unpartitioned and partitioned table respectively:

• INSERT INTO TABLE
• SELECT FROM TABLE (to validate the inserted data)

Willingness to contribute

I can contribute to this feature independently