Feature Requests
Anonymous

Direct Database query Tutorial Document: SQL Common Syntax Examples and Recommendations

  1. Regarding the documentation for Direct Database SQL, please add common syntax examples, such as how to use "WHERE IN" with "ANY(string_to_array(trim(both '[]' from ?), ','))".

  2. If you want to query a JSON array as if it were a table alongside a database, you can use the following query as an example for joining "temp_table" with the Xano database:

    SELECT json_data->>'ProductNo' AS sku, (json_data->>'GoodStockQty')::integer AS GoodStockQty
    FROM (SELECT json_array_elements(?::json) AS json_data) AS temp_table

1