id
field has been seen before. In order to enable this feature, your SQL query must return an id
field. A clever way of doing so is by naming whichever column you wish to designate as the identifier as id
in your SQL query e.g.select user_id as id from accounts