Sync, Model methods differences?

[amitava82]

Model has query, save, fetch, destroy methods and Sync has similar methods (first, select, insert, update, del) as well. What's the difference between two or they can be used interchangeably?

To query I could use Model.query().where() or I can use sync.select([options])

[tgriesser]

@amitava82 you actually don't want to use sync directly, it is really only documented for explanation purposes (in-case you want to extend) and primarily used internally. What you'll want to do is use save, fetch and destroy on the models/collections... if you need to use the query method, it's often to tap into the query chain for the current object.

// resolves with a Bookshelf model
model.query('where', 'id', '>', 30).fetch().then(...

// resolves with a response array, might as well be using Knex at this point
model.query().where('id', '>', 30).select().then(...

[amitava82]

Got! Thanks! Might as well make a note of it in the doc. Newbies (like me :p) won't get confused. Closing