And sorry for the Spam. But, having had cake, I really do like cake, and i do beleive I have deliberatly forced a query to result with an object of group:{} and users: {} information in the group.
But, having worked motstly with MySQL/MSSQL through ODBC, that's why I would expect select count(*) count from table alias to have a origin column name of 'count(*)' (not null), an alias of 'count' , a table name of 'table' and a table alias of 'alias'. Although the ODBC stuff doesn't actually give you the choice to get the origin names of things. On Sun, Aug 18, 2019 at 5:01 PM J Decker <d3c...@gmail.com> wrote: > Okay let's start with, I originally had an API compatible with ODBC, which > the third information parameter is 'The name of the table, view, alias, > or synonym.' > > > https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/odbc/src/tpc/db2z_fncolumns.html > > > > Column 1 TABLE_CAT (VARCHAR(128))The name of the catalog. The value is > NULL if this table does not have catalogs.Column 2 TABLE_SCHEM > (VARCHAR(128))The name of the schema containing TABLE_NAME.Column 3 > TABLE_NAME (VARCHAR(128) not NULL)The name of the table, view, alias, or > synonym.Column 4 COLUMN_NAME (VARCHAR(128) not NULL)The column > identifier. The name of the column of the specified table, view, alias, or > synonym.Column 5 DATA_TYPE (SMALLINT not NULL)The SQL data type of the > column that is identified by COLUMN_NAME. The DATA_TYPE is one of the > values in the Symbolic SQL Data Type column in the table of symbolic and > default data types for CLI.Column 6 TYPE_NAME (VARCHAR(128) not NULL)A > character string that represents the name of the data type that corresponds > to DATA_TYPE.Column 7 COLUMN_SIZE (INTEGER) > > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users