I'm not an expert by any means but there's a clip in another comment I made about some of Houston's zoning stuff, I'm curious what you think.
8 karma · joined April 9, 2014
https://nebula.app/videos/not-just-bikes-the-houses-that-can...
A clip about Houston zoning specifically is in the "Why City Design is Important (and Why I hate Houston)" video at 12:30.
https://nebula.app/videos/not-just-bikes-why-city-design-is-...
It sounds like you've delegated if statements to configurable SQL queries, does that mean you need to take the context/variables/code and put it into a temporary SQL db whenever you evaluate them. Is the overhead of moving state into and out of SQLite a lot?
It reminds me of SQL stream processing in Fluentbit https://docs.fluentbit.io/manual/stream-processing/getting-s...