#:package Microsoft.Data.Sqlite@10.0.12
// dotnet run scripts/Query.cs -- <cad_index.db> <sql>
using Microsoft.Data.Sqlite;

using var connection = new SqliteConnection($"Data Source={args[0]};Mode=ReadOnly");
connection.Open();
using var command = connection.CreateCommand();
command.CommandText = args[1];
using var reader = command.ExecuteReader();
int righe = 0;
while (reader.Read())
{
    righe++;
    var valori = Enumerable.Range(0, reader.FieldCount).Select(i => reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString());
    Console.WriteLine(string.Join(" | ", valori));
}
Console.WriteLine($"({righe} righe)");
return 0;