2 ms·

It sounds like a JSON_TABLE function: https://docs.oracle.com/database/121/SQLRF/functions092.htm#SQLRF56973 https://docs.oracle.com/database/121/SQLRF/function

by morgo 10y ago

It sounds like a JSON_TABLE function: https://docs.oracle.com/database/121/SQLRF/functions092.htm#SQLRF56973 https://docs.oracle.com/database/121/SQLRF/functions092.htm#... We are looking to add something similar.

chrishynes 10y ago
That looks perfect, looking forward to it! I was doing a little more research and it looks like MySQL doesn't support table valued functions at all right now -- not built-ins, not custom. I didn't realize that, I guess I just assumed that was a fundamental feature. Probably explains the longstanding lack of STRING_SPLIT() etc., I guess. Here's hoping you are able to get in a more generic support for table valued functions, including stuff like STRING_SPLIT() as well as custom table returning functions.