Allow using shorthand notiations in the Query function when defining names of tables

[absundr]

Problem area

Query("TableName") does not accept shorthand notations to reference the table. This can be painful when you have a lot many columns and you're performing a join with another table which clashing columns.

In this scenario, you are required to prefix the entire TableName to the column, likes so

Query("TableName").Select("TableName.Column")

You can see how this would be painful in writing columns in the hundreds.

Suggested fix

Allow the Query object to accept a shorthand accessor for the table name which can be used to prefix the required columns.

Like so,

Query("TableName tb).Select("tb.Column")

This will make things so much easier.

[ahmad-moussawi]

You can do it by writing

var query = new Query("TableName as tb").Select("tb.Column")

check this example

the as keyword is the key here.

in addition you can expand the selection to avoid repeating the table name many time

var query = new Query("TableName as tb").Select("tb.{ColumnA, ColumnB, ColumnC}");

This will output the following SQL

SELECT [tb].[ColumnA], [tb].[ColumnB], [tb].[ColumnC] FROM [TableName] AS [tb]

[absundr]

I wasn't aware this could be done. It's super helpful. I'm wondering why it doesn't say anywhere in the documentation.

Thanks btw

[ahmad-moussawi]

Yes the docs is outdated now.