Dump Sqlite Table using PowerShell

dump-sqlite.ps1

$SqliteAssembly = Resolve-Path -LiteralPath '~\scoop\apps\scoop\current\supporting\sqlite\System.Data.SQLite.dll'
$DbPath = Resolve-Path -LiteralPath '~\AppData\Roaming\Code\User\globalStorage\state.vscdb'
if (!('System.Data.SQLite.SQLiteConnection' -as [Type])) {
    Add-Type -Path $SqliteAssembly
}

$connection = New-Object -TypeName 'Data.SQLite.SQLiteConnection'
$connection.ConnectionString = "Data Source=$DbPath"
$connection.Open()
$command = $connection.CreateCommand()
$command.CommandText = @"
SELECT json_extract(value, '$.entries')
AS entries
FROM ItemTable
WHERE key = 'history.recentlyOpenedPathsList'
"@
$command.CommandType = [Data.CommandType]::Text
$reader = $command.ExecuteReader()

# Colnames: $reader.GetValues()
while ($reader.HasRows) {
    if ($reader.Read()) {
        $reader['entries']
    }
}
$reader.Close()
$command.Dispose()