For simplicity, we recommend using only lower case identifiers for all table/collection and column/field names used in PowerSync. If you need to use a different case, continue reading.
SELECT *
, the original case is preserved for the returned columns/fields.
SELECT description FROM todos WHERE listid = ?
.
Operations (PUT
/PATCH
/DELETE
) are stored in the upload queue using the case as defined in the schema above for table and column names, not the case used in queries.
As another example, in this Sync Rule query: