Hey Stefano, Not all SQL types are supported for conversion to Python Objects; right now the only types that are supported are strings, numeric types, decimals and date/date time objects. JSON objects are not currently supported, so you would indeed need to store them as strings. Regards, Mark ----- Original Message ----- From: "Stefano Fioravanzo" <fioravanzos@gmail.com> To: "users-list" <users-list@monetdb.org> Sent: Wednesday, June 1, 2016 2:28:55 PM Subject: query json from embedded py Hello, I am trying to query a table with a JSON field with a loopback query in embedded python. I get this error: SQL Query Failed: MALException:pyapi.eval:Unsupported SQL Type: son Is JSON not supported? Do I have to store the JSON object as a string in case I want to query it from python? Thank you, Stefano _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list