I'd like to make a request that I think will be pretty useful to development, as often times there are cases where using the db.executeQuery(query, obj[]) method is very useful, but there is a limitation if there is an "AS" alias in the query. Sometimes the "AS" clause (eg. SELECT `id` AS user_id ) is required in a query because two fields in a cross-query have the same name, or you'd like to conveniantly shorten the field names and package them as such into the SFSObject.
On testing, I found that the ResultSetMetaData from a ResultSet contains two functions : getColumnLabel() and getColumnName()
The getColumnName() method uses the original name and not the new alias, so I was wondering if it's possible to use the getColumnLabel() instead from the ResultSetMetaData, as this is more conveniant to structure the resulting SFSObject with ease. In some situations, there is no choice but to manually generate the SFSObject, in such circumstances.
Another request is to allow tinyint(1) types as Boolean objects in a result, otherwise there is an error appearing
Code: Select all
serialization.DefaultSFSDataSerializer - Skipping Unsupported SQL TYPE: -7
Thanks