order in select query

[bakhodir10]

https://github.com/goodybag/mongo-sql/blob/master/docs/query-helpers.md#helper-order

Here is documentation and there is written // select "users".* from "users" order by "order"."id" desc, "order"."name" asc { type: 'select' , table: 'users'

// Object syntax is the preferable way since it can automatically // quote your columns and add in the default table , order: { id: 'desc', name: 'asc' } , order: ['id desc', 'name asc'] , order: 'id desc' } but when I use order: { id: 'desc', name: 'asc' } it shows the error that "{ error: syntax error at or near "order". Then I tested orderBy: { id: 'desc', name: 'asc' } and it is working correctly.

[CvBlixen]

Maybe I'm misunderstanding the question @bakhodir10, but when i try

{
  type: 'select',
  table: 'users',
  order: { id: 'desc', name: 'asc' }
}

on the playground it results in

select "users".* from "users" order by "users"."id" desc, "users"."name" asc