Add QuerySetRow, Query.setRow() and allow returning an array from QueryRowData


as discussed on the mailing list

Basically it's QueryAddRow, but allowing it to update an existing row with data

This will allow developers to avoid using QuerySetCell for every column when manipulating
an existing query row.

QueryRowData currently only returns a struct, add an option to return an array, which can
then be passed into QuerySetRow()


Dave Merrill
May 13, 2018, 10:29 AM

Adding querySetRow() makes perfect sense, but the struct syntax for adding a row makes more sense to me, so I don't see the need for queryRowData() to return an array.

Zac Spitzer
May 13, 2018, 10:46 AM

Adding a row via array is way more efficient that via a struct which requires name matching for each column

Dave Merrill
May 14, 2018, 10:28 AM

Point taken, so I suppose the array version would be preferable when highest performance is required. Absent that priority though, the struct version is way more readable IMO, especially in a query with many columns, or where you only want to set a few columns.

Zac Spitzer
October 22, 2020, 7:27 AM

initial cut (doesn’t quite compile yet, notes in PR)

Sebastian Zartner
October 23, 2020, 5:19 PM

Just to have the reference, the PR is .



Zac Spitzer


Zac Spitzer