REQ: JSON query using the extract (->) operator

Bug or feature request

• Bug
• Feature request

Description of feature (or steps to reproduce if bug)

SQLite3 3.38 of Feb 2022 has support for json extract -> not unlike Postgres and MySQL. This connector should be updated to use that if possible.

• SQLite documentation: https://www.sqlite.org/json1.html#jptr
• loopback-connector-postgresql commit: https://github.com/loopbackio/loopback-connector-postgresql/commit/d9121644abe667a2b7d7244068d99b81b593effe

No data type change is needed -- it's still TEXT.

Expected result

I hope the final interface is the same as the Postgres connector. The PG example is:

Customer.find({
  where: {
    'address.state': 'California'
  },
  order: 'address.city'
})

Additional information (Node.js version, LoopBack version, etc)

Eh, doesn't really matter here. No code for this stuff present is no code for this stuff present.

It's also not like people use loopback with sqlite3 for super serious business things, so don't put the priority too high. It's just nice to make it capable of this JSON stuff so people can experiment on a minimal setup.

Bắt đầu với tài liệu SQLite JSON1 và commit loopback-connector-postgresql được liên kết. Theo dõi cách connector này xử lý các đường dẫn JSON lồng nhau cho ví dụ where và order được yêu cầu của Customer, sau đó xác minh rằng việc trích xuất JSON hoạt động trong khi các giá trị vẫn là TEXT.