You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This is also inspired by the SQLite WASM lib, where you can configure the 'rowMode' property as object or array
Describe the solution you'd like:
I would like to be able to configure if a SQL Query returns the result as Object or as two dimensional array.
For Example:
Old: [{col1: "value1"}]
New: [["value1"]]
It would be nice if it would be possible to configure this per query or on the Connection. Maybe make it hierarchical.
For compatibility reasons the default should stay with objects.
Describe alternatives you've considered:
Transform object to array. But this might be tricky because the order of columns must match the sql statements order
The text was updated successfully, but these errors were encountered:
Is your feature request related to a problem? Please describe:
I use other SQL Libraries which expect the results as two dimensional array.
As far as i can see, the object logic is also self implemented (only checked android) https://github.com/capacitor-community/sqlite/blob/master/android/src/main/java/com/getcapacitor/community/database/sqlite/SQLite/Database.java#L984
This is also inspired by the SQLite WASM lib, where you can configure the 'rowMode' property as object or array
Describe the solution you'd like:
I would like to be able to configure if a SQL Query returns the result as Object or as two dimensional array.
For Example:
Old:
[{col1: "value1"}]
New:
[["value1"]]
It would be nice if it would be possible to configure this per query or on the Connection. Maybe make it hierarchical.
For compatibility reasons the default should stay with objects.
Describe alternatives you've considered:
Transform object to array. But this might be tricky because the order of columns must match the sql statements order
The text was updated successfully, but these errors were encountered: