id
column must always be present, and must have a text
type. If the primary key is different, use a column alias and/or transformations to output a text
id column.
_id
as the name of the ID field in collections. Therefore, PowerSync requires using SELECT _id as id
in the data queries when using MongoDB as the backend source database.