Currently when trying to reference a column status in an INSERT statement an error is reported:
create table x(status int);
insert into x(status) values (42);
This is a bit awkward since:
- in MySQL
status is a keyword only and not a reserved word
- using the
status identifier for the column name in the CREATE TABLE statements works fine
I think it would make sense to allow status to be used in unquoted form in the INSERT statement as well. This may also apply to other DML statements.
Additionally, if Dolt SQL is different from MySQL with regards to what are keywords and reserved words, it would make sense to document this.