Add tests for new parser options

Thanks @niebayes -- this makes sense to me

Could we please add some sort of test to amke sure we don't accidentally break this in the future? Like maybe a query that requires `enable_ident_normalization` ?

_Originally posted by @alamb in https://github.com/apache/datafusion/pull/14822#pullrequestreview-2641651180_

Start by locating the parser option `enable_ident_normalization` and the existing parser or query tests. Add a query-based test that exercises this option and verifies the expected behavior, as requested in the issue; done means the test prevents the new parser option from regressing.

Written by the indexing model from the issue text.