examples-sql-method/03-read-json.ps1

Import-Module $psscriptroot\..\PSDuckDB.psd1 -Force

# psduckdb -command "SELECT * FROM '$PSScriptRoot\..\data\json\sales1.json';" | Format-Table

$db = New-DuckDBConnection

$db.sql("SELECT * FROM '$PSScriptRoot\..\data\json\sales1.json';") | Format-Table

$db.CloseDB()