Full official docs can be found here: https://surrealdb.com/docs/integration/libraries/nodejs
The AdvancedQuery function allows you to enter a SurrealQL query. The other functions will behave as outlined in the above docs.
You can perform operations on specific documents by using colon, e.g. Collection: person:a1 will select the person document with id a1.
Budibase connector for performing CRUD ops against SurrealDB
To get started, you will want to make sure a namespace and database has been defined: https://surrealdb.com/docs/surrealql/statements/define/database
Then you can connect in Budibase:
Note that host.docker.internal is being used here because I am running Budibase in a local docker container connecting to a local SurrealDB instance.
This is the equivalent of creating a record with the CONTENT keyword (https://surrealdb.com/docs/surrealql/statements/create).
If the collection does not already exist, it will be created.
To update a specific record in a collection, provide the id after the collection name, separated by a colon. E.g. person:id
Check out the docs to see how to add a custom plugin: https://docs.budibase.com/docs/custom-plugin