Add named parameters support

[ibilux]

Hello,

Can we have support for named parameters ?

Thank you.

[DallasHoff]

Can you elaborate more on what you're suggesting?

[ibilux]

Can you elaborate more on what you're suggesting?

I mean binding parameters in SQLite, the named parameters are prefixed with :, @, or $.. Something like:

INSERT INTO users (name, age) VALUES (:name, @age);

The @sqlite.org/sqlite-wasm already support named parameters.

I can see that SQLocal support positional parameters with ? placeholders from the tests:

sqlocal/test/sql.test.ts

Lines 49 to 51 in c105867

	const sqlStr = 'SELECT name FROM groceries WHERE id = ?';
	const select3 = await sql(sqlStr, 1);
	expect(select3).toEqual([{ name: 'bread' }]);

What I'm suggesting is to be able to pass an object with named params to the api methods. Something like:

const sqlStr = await sql('INSERT INTO groceries (name) VALUES (:name)', { name: 'bread' });  

[DallasHoff]

Ah, I see now. Yeah, that would be good to have. Thanks for your PR. I'll look it over.