ExecuteQuery for unknown # of fields about sqlite-net HOT 13 OPEN

    public List<Dictionary<string, object>> ExecuteQuery()
    {
        return ExecuteDeferredQuery().ToList();
    }

   public IEnumerable<Dictionary<string, object>> ExecuteDeferredQuery()
    {
        if (_conn.Trace)
        {
            Debug.WriteLine("Executing Query: " + this);
        }

        var stmt = Prepare();
        try
        {
            var cols = new string[SQLite3.ColumnCount (stmt)];

            for (int i = 0; i < cols.Length; i++) {
                var name = SQLite3.ColumnName16 (stmt, i);
                cols [i] = name;
            }

            while (SQLite3.Step(stmt) == SQLite3.Result.Row)
            {
                var obj = new Dictionary<string, object>();
                for (int i = 0; i < cols.Length; i++)
                {
                    var colType = SQLite3.ColumnType(stmt, i);

                    Type targetType;
                    switch (colType)
                    {
                        case SQLite3.ColType.Text:
                            targetType = typeof(string);
                            break;
                        case SQLite3.ColType.Integer:
                            targetType = typeof(int);
                            break;
                        case SQLite3.ColType.Float:
                            targetType = typeof(double);
                            break;
                        default:
                            targetType = typeof(object);
                            break;
                    }

                    var val = ReadCol(stmt, i, colType, targetType);
                    obj.Add(cols[i], val);
                }
                OnInstanceCreated(obj);
                yield return obj;
            }
        }
        finally
        {
            SQLite3.Finalize(stmt);
        }
    }

var results = db.Query<Dictionary<string, object>>(query, query_params);

    public List<T> ExecuteQuery<T> () where T : new()
    {
        return ExecuteDeferredQuery<T>(_conn.GetMapping(typeof(T))).ToList();
    }

    public List<Dictionary<string, object>> Query2(string query, params object[] args)
    {
        var cmd = CreateCommand(query, args);
        return cmd.ExecuteQuery();
    }

var results = db.Query2(query, query_params);

public partial class SQLiteConnection
{
	public List<ExpandoObject> Query(string query, params object[] args)
	{
		var cmd = CreateCommand (query, args);
		return cmd.ExecuteQuery();
	}
}

public partial class SQLiteCommand
{
	public List<ExpandoObject> ExecuteQuery() {
		return ExecuteDeferredQuery().ToList();
	}

	private IEnumerable<ExpandoObject> ExecuteDeferredQuery () {
		if (_conn.Trace) {
			_conn.Tracer?.Invoke ("Executing Query: " + this);
		}

		var stmt = Prepare ();
		try {
			var cols = new string[SQLite3.ColumnCount (stmt)];

			for (var i = 0; i < cols.Length; i++) {
				var name = SQLite3.ColumnName16 (stmt, i);
				cols[i] = name;
			}

			while (SQLite3.Step (stmt) == SQLite3.Result.Row) {
				var obj = new ExpandoObject() as IDictionary<string, object>;
				for (var i = 0; i < cols.Length; i++) {
					var colType = SQLite3.ColumnType (stmt, i);

					var val = ReadCol (stmt, i, colType, MapToCSharpType(colType));
					obj[cols[i]] = val;
				}
				OnInstanceCreated (obj);
				yield return (ExpandoObject) obj;
			}
		}
		finally {
			SQLite3.Finalize (stmt);
		}
	}

	private Type MapToCSharpType (SQLite3.ColType colType)
	{
		Type targetType;
		switch (colType) {
			case SQLite3.ColType.Text:
				targetType = typeof (string);
				break;
			case SQLite3.ColType.Integer:
				targetType = typeof (int);
				break;
			case SQLite3.ColType.Float:
				targetType = typeof (double);
				break;
			case SQLite3.ColType.Blob:
				targetType = typeof (byte[]);
				break;
			default:
				targetType = typeof (object);
				break;
		}

		return targetType;
	}
}