// creating database and table with PK
await alasql.promise(`
	CREATE INDEXEDDB DATABASE IF NOT EXISTS geo;
	ATTACH INDEXEDDB DATABASE geo;
	USE geo;
	DROP TABLE IF EXISTS cities;
	CREATE TABLE cities (city STRING PRIMARY KEY, population NUMBER);
`);

// round 1
await alasql.promise('INSERT INTO cities SELECT * FROM ?', [
	[
		{ city: 'Redmond', population: 57530 },
		{ city: 'Atlanta', population: 447841 },
	],
]);
console.log('ROUND 1', await alasql.promise('SELECT * FROM cities'));
/*
	[
		{city: 'Redmond', population: 57530},
		{city: 'Atlanta', population: 447841}
	]
*/

// round 2
await alasql.promise('INSERT INTO cities SELECT * FROM ?', [
	[
		{ city: 'Redmond', population: 42 },
	],
]);
console.log('ROUND 2', await alasql.promise('SELECT * FROM cities'));
/*
	[
		{city: 'Redmond', population: 57530},
		{city: 'Atlanta', population: 447841},
		{city: 'Redmond', population: 42}      // <--- why?
	]
*/