[Feature Request]: Support for missing SQL data types

[hanieas]

Description

After reviewing the current table statement implementations, I noticed that some types are not yet supported, including BOOLEAN , ENUM , SET, and JSON. I would like to contribute by implementing these missing statements.

@brendt @aidan-casey Would it be acceptable to work on these types and submit them as separate PRs?

Benefits

/

[brendt]

Definitely!