sqlite: Use upsert

[oncilla]

The go sqlite3 driver ships with its own sqlite3 implementation. Luckily, that is 3.24.0 and supports upsert.

We should move the beacondbsqlite and pathdbsqlite to use upsert to avoid one app-db roundtrip

[lukedirtwalker]

Do we already have a new enough version of the lib?

[oncilla]

The vendored library should be new enough, yes

[matzf]

Just as an update: currently there are two different sqlite implementations that we can build against:

• modernc.org/sqlite v1.24.0, sqlite version 3.41.2
• github.com/mattn/go-sqlite3 v1.14.17, sqlite version 3.42.0

So both versions should fully support upsert (last update according to the see docs was in in sqlite 3.35.0).