surrealdb connector

[Hebilicious]

Describe the feature

https://surrealdb.com/docs/integration/sdks/nodejs

This is more exotic, and could be out of scope, should we focus just on SQL like things ?

This is what SurrealQL looks like :

let groups = await db.query('SELECT marketing, count() FROM type::table($tb) GROUP BY marketing', {
			tb: 'person',
		});

It's not a SQL db, but the syntax share some similarities.

Additional information

• Would you be willing to help implement this feature?

[pi0]

I am thinking to start with only focusing on SQL/lite-compatible drivers because otherwise, the user code needs to be changed per connector (and higher order ORMS cannot know how to generate queries).

We can BTW introduce this as experimental non-sql driver and see if useful but at least we need query preparation support.

[pi0]

Moving to single tracker #32 for maintenance.