search

mk3008 / Carbunql

Carbunql provides query parsing and building functionality.
https://mk3008.github.io/Carbunql/
MIT License
40 stars 3 forks source link

[Experiment] TypeSafe Query Builder - Behavior when the select clause is omitted #426

Closed mk3008 closed 1 month ago

mk3008 commented 1 month ago

If the select clause is omitted, all columns will be selected. The "*" keyword must not be used. All columns will be selected even if a table join is performed. Note that if there are duplicate column names, the table referenced first will take priority. If this specification is not met, the workaround is to manually declare the select clause.

mk3008 commented 1 month ago

I will not do this because of the following difficulties.

I think it is possible to get the column names if TableBase is a PhysicalTable.

However, when tables other than Physical Tables are mixed in, it is necessary to re-express them using "*", which is a bit of a hassle.

I am interested in this issue, but since the content is similar to the following issue, I will not do this for now.

[Experiment] TypeSafe Query Builder - Allows you to specify a DataSet in the select clause #430