Cover Most Popular and Advanced Query Features

[drveresh]

Documentation Area

Whenever applicable

Current Documentation Link

https://docs.sqlitecloud.io/docs/edge-functions

Description of Changes

Please cover the most popular and advanced examples of queries, or else the end users end up wasting an enormous amount of time and effort guessing its solutions. The current set of documents contains very rudimentary examples (SELECT query by integer ID) which are often less useful, because most applications required more advanced queries, like having multiple conditions,

Rationale

Adding the most common and advanced examples will help end users to quickly apply it in the product and speed up the development.

Examples and Code Snippets

[1]. The below line fails if >1 value is in the IN query, especially if string values like ('JP','DE')
result = await connection.sqlSELECT * FROM products WHERE country IN (${values}) LIMIT 6;
[2]. Below one is failing if the query is formed outside that connection.sql context:
result = await connection.sql${myQuery};

Additional Context and Relevant Repos

1. The overall documentation is poor
2. The Live logs are not getting latest logs quickly, sometimes loading indefinitely