MonetDB.jl

MonetDB.connect("localhost", 50000, "monetdb", "monetdb", "demo")

df = MonetDB.execute(conn, "SELECT 1 AS \"foo\",2 AS \"bar\"")

1×2 DataFrame
 Row │ foo     bar
     │ String  String
─────┼────────────────
   1 │ 1       2

MonetDB.connect("localhost", 50000, "monetdb", "monetdb", "demo")

MonetDB.load(conn, my_df, "my_table")

MonetDB.connect("localhost", 50000, "monetdb", "monetdb", "demo")

prepared_statement = MonetDB.prepare(conn, "SELECT id, foo, bar FROM my_table WHERE bar = ?")

df = MonetDB.execute(conn, prepared_statement, ["there"])

MonetDB.connect("localhost", 50000, "monetdb", "monetdb", "demo")

MonetDB.transaction(conn) do
   MonetDB.execute(conn, "INSERT INTO my_table VALUES ('foo')")
end