For SQL queries at least it would be nice to have a check box that performed a formatDataAsArray() rather than having to put it into the query transformer.
Or maybe to be more precise an option like: Return as Object / Return as Array.
For SQL queries at least it would be nice to have a check box that performed a formatDataAsArray() rather than having to put it into the query transformer.
Or maybe to be more precise an option like: Return as Object / Return as Array.
Seconding! This would be incredibly helpful. It's very strange how queries from Google Sheets and queries from SQL Select statements return data in different formats - it keeps tripping me up!