Is there a way in sqldelight to just let me put in...
# squarelibraries
s
Is there a way in sqldelight to just let me put in some raw SQL, and have it ignore any syntax issues that it might think are there? i.e. I can’t use the
DATE_ADD
function with the
INTERVAL
syntax, because it shows a type error:
Copy code
INSERT INTO PendingInstallation(
    id,
    verification_code,
    expiration
) VALUES (
    UUID(),
    UUID(),
    DATE_ADD(now(), INTERVAL 2 HOUR)
);
It seems unreasonable for me to expect that sqldelight can just magically support every nook and cranny of the mysql dialect, and I really enjoy the typesafety it gives me on SELECT statements, and the parameter names etc on other statements, but I feel like most of the interesting things I’ve been working with today, I’ve spent time trying to work around using mysql features that sqldelight doesn’t seem to support.