Failing on inserting text containing ' about mysqlite HOT 2 OPEN

I run into problems with quotes often. That is a SQL issue more than anything. I would hesitate to modify the query. But I could try to perform some type of validation check and present a warning.

from mysqlite.

Dodgy workaround Jeff, if it works it's ok isn't it ;-)?

$jsonData | ForEach-Object -Begin {
$cx = Open-MySQLiteDB $dbpath
} -Process {
try {
$item = $.Item -replace "'", "''"
$value = $.Value -replace "'", "''"
$query = "INSERT INTO asd VALUES (
'$($.H3)',
'$($.H4)',
'$($.H5)',
'$($.Title)',
'$($.Filename)',
'$($.Weight)',
'$($.Url)',
'$item',
'$value'
)"
Invoke-MySQLiteQuery -Connection $cx -KeepAlive -Query $query
} catch {
Write-Host "Error: $"
}
} -End {
Close-MySQLiteDB $cx
}

from mysqlite.