Use column LETTER as field name.

[demmings]

• gsSQL currently requires unique column titles for the input data range.
• Currently, the column titles are used as the field name.
• The suggested enhancement would be to use the column letter as field name when column titles are not available.
• The column letter will use relative position in the data range, so the first column in the range will be column 'A'.
• This is different than the current Sheets implementation where the physical column name is always used.
• The problem with the Google approach is that when columns are inserted/remove prior to the range, the QUERY fails since the columns are different.

? Is there a good way to know that no column titles exist and therefore expect letters for columns, OR should we just analyze the SELECT statement and figure out if only letters are used (only necessary if no table definition).

• Add a new table definition parameter to indicate if column titles are available.

[demmings]

A new parameter for data definition now includes a flag to indicate if a column title is available. If no column title is available, then fields are referenced a column letters starting in the first column as A.

This is implemented slightly different from QUERY() in that the first column of the data is always A. So if the table data is specified in a RANGE and the range is taken starting from column F, gsSQL() would reference this first column as A in your SELECT statement.