var client = new RqliteClient("https://localhost:4001"); //Assuming you have rqlite running on that port locally
var version = await client.Ping();
var queryResults = await client.Query("select * from foo");
var executeResults = await client.Execute("insert into foo (name) values('test')");

public class FooResultDto
{
    public int Id { get; set; }
    public string Name { get; set; }
}
var rqClient = new RqliteOrmClient("https://localhost:6000");
var queryresults = await rqClient.Query<FooResultDto>("select * from foo"); //Returns List<FooResultDto>