the translation step from binary (program) -> text (SQL) -> binary (server)

Your concern about this is misguided. Inter-process communication always has to cross a barrier, by definition.

I take it http also feels wrong to you?

Binary protocols do exist, e.g. gRPC, but they incur costs of their own.

Shame I had to scroll this far to find PRQL

Great boast for privacy. Removes a lot of attack surface that law could exploit. And potentially reduces running costs, too.

Glad to hear you’re building the kernel too.

Do what now? Sorry, I’m a frontend developer, I don’t have much experience with C##

Yes… YESSS… he’s going to attach the debugOH FUCK IT he’s just ADDED a fucking PRINT STATEMENT instead.

Why can’t I get this programmer to debug?

Ugh, a Magic String (I call it that whatever the type)

FACILITY_MAX_PRESSURES = {
    "Durham": 1000,
    "Ipswich": 500,
    "Calne": 750,
}

max_pressure = list(sorted(
    FACILITY_MAX_PRESSURES.values()
))[-1]

if water_pressure > max_pressure:
    blah

Obviously it should really pull from facility management, but that’s a bunch of moving parts where a constant is how you’d prefer the code to work

Tbh it starts to look better to just define a constant and comment it.