[Java] driver/flight-sql: Add Dremio validation suite

I plan to run validation suite against Dremio Flight SQL interface, but I'd like to hear some feedback on my initial thoughts.

I think we need a `flight-sql-validation-dremio` maven submodule to accomplish it as most of dremio quirks wouldn't make sense in a generic `flight-sql-validation`. I'm thinking of either adding a new submodule or maybe renaming the existing submodule to `flight-sql-validation-dremio` as imho it doesn't really make much sense to define quirks for an abstract flight-sql source anyway (there's no `jdbc-validation` suite for similar reasons, I'm guessing). Another option would be to rename the existing one to `flight-sql-validation-derby` to highlight that it should be run against derby flight-sql example from arrow repo.

Start by reading the existing flight-sql-validation submodule and the validation setup for the Arrow Flight SQL example. Clarify whether Dremio-specific quirks belong in a new flight-sql-validation-dremio module or whether the existing module should be renamed to flight-sql-validation-derby. Done means agreeing on the module structure and adding a runnable Dremio validation suite.

Written by the indexing model from the issue text.