Support for DDL statements?

[joegrasse]

Based on pull request #10, it looks like DDL statements are supported. Is that correct?

[tejasmanohar]

DDL are supported, but their result/output is somewhat broken (though you likely don't need that, I never have) since we skip the first line of Athena results (for SELECTs, it contains the header). That PR would fix this but lacks tests.

Feel free to pick up on it!

[joegrasse]

Ok, thanks.

[muroon]

Recently, we released speee/go-athena.

We have already merged the PR related to this issue and can keep maintaining this library and review / merge your PRs.
In addition, we added the following new features.

• Add Docker environment
• Add reviewdog configuration for linting
• Remove Result Header when executing DDL
• Use workgroup
• Update tests (make each package up to date)
• Introduce Result Mode (Query result acquisition mode)

Especially, we think the Result Mode is a cool feature, and we summarized the feature here.
Please check and try to use it!

[bhavanki]

Summarizing work done since back in the day:

• Original fix without tests, not merged: Do not skip headers for DDL #10
• Subsequent merged update with ability to skip headers, but not addressing DDL specifically: fixed missing row issues due to skipping heade row in each page of responses(#12) #13
• Second attempt at fix building on fixed missing row issues due to skipping heade row in each page of responses(#12) #13 but most likely the reverse of what's needed: [FIX] Skip header row when not a DDL query #31