brunoc1989
DTDrizzle Team
•Created by brunoc1989 on 7/13/2023 in #help
Execute sql with '?' as parameter
Hello @Andrew Sherman , I apologize for mention you here, but I'd like to inquire about the possibility of addressing my doubt. As drizzle lacks a UNION function, I wonder if there is a way to "group" multiple SQLs generated with the toSQL() function, which could be quite helpful.
4 replies
DTDrizzle Team
•Created by brunoc1989 on 7/13/2023 in #help
Execute sql with '?' as parameter
Hello, thank you for the response.
But this way doesn't work for me. What I need to do is combine several SQL queries made in Drizzle into a UNION. So, I'm trying to use the sql.toSql() command on these multiple SQL queries, converting them to strings and manually adding the UNION. However, I can't find a way to execute an SQL query returned by the toSql() function because it returns the parameters with "?". That's why I'm wondering how to execute queries with "?", because it seems a bit strange to me that there isn't a way to execute an object returned by toSql().
4 replies