How to use dynamic sql in edge function sql mode

[Md-Rohol-Amin]

I want to use dynamic sql in edge function sql mode. Someone can tell me its possible to here. If its possible then please give me an example.
Already i have tried by bellow syntax like ,
{{sql}} its my sql edge function command, but when is execute from postman then it got "Unable to find command {{sql}}."
Thanks to all.

[danielebriggi]

Can you please provide us the example of your code?

[Md-Rohol-Amin]

hello @danielebriggi please follow this.

[danielebriggi]

Thank you Rohol. Do you call the Weblite /v2/weblite/sql or your custom Edge Function?
If it's your custom Edge Function, can you please also share the example of the code?

[Md-Rohol-Amin]

Hello @danielebriggi its not my custom edge function, just i want to execute dynamic query by this process. I think you understand by looking at the example above. Do you know this is a valid syntax for the edge function? I need this process for just bulk insert. again a big Thanks @danielebriggi

[danielebriggi]

The SQL type of Edge Function must be implemented with an SQLite query to run it when called. You can use $ like $filter to customize it with inputs.
If you just need to run a custom query on your database via HTTP you can use the ready-to-use Weblite API. In your case you need this one:
POST /v2/weblite/sql - Run SQL on the nodes
The payload is:

{
  "sql": "SELECT * FROM artists WHERE ArtistId = ? OR ArtistId = ?",
  "bind": [
    1,
    2
  ],
  "database": "chinook.sqlite"
}

More information can be found in the Weblite section in your Dashboard where you find the full address of the API for your project.
You can also try the API right on that section.

[Md-Rohol-Amin]

A big thanks to @danielebriggi for your feedback. I understand, it's not possible to here. I think the SQLite Cloud team needs to work on dynamic SQL pattern queries in sql mode edge function, if possible. 😀😀😀

[danielebriggi]

can you please give us an example of what you'd like to achieve? I was sure Weblite could have been helpful to your purpose