tresql

I'm really excited about languages that build on or are compiled to SQL, in the long-term (because I think it will take a very long time to build adoption). The ones that particularly excite me are shorthands for SQL, even though their heavy use of symbols may be a detriment. One particular use case is in easily defining static authorization policy-queries that are backed by database data plus and have request variables injected during evaluation. I am not very excited by datalog/prolog-based languages because I think logic languages are too unnatural to ever go mainstream. But I'd be excited to be wrong or for logic languages to become more friendly. Here are some others I'm watching. * https://github.com/mrumkovskis/tresql * https://www.htsql.org/doc/overview.html * https://github.com/cytosm/cytosm

Are there any policy-language-libraries-backed-by-sql like Polar but that aren't based on logic programming languages? I don't really want to learn logic programming for this purpose nor do I want to require it on my coworkers. I guess I'm just looking for a library + SQL shorthand that can easily interpolate request variables and session variables that gets declared in code where a route is declared. Just spitballing but something like `(blogs.id = $req.blogid).userid = $session.userid OR (users.id = $session.userid).isAdmin`. This [0] is close but it doesn't have enough momentum to be well documented let alone usable as a library in every language you'd want (Go, C#, Python, Node.js, etc.). Edit: Maybe OPA/Rego can in fact do this [1]. [0] https://github.com/mrumkovskis/tresql [1] https://blog.openpolicyagent.org/write-policy-in-opa-enf

Been working on a similar project [0] with a simpler architecture. You supply a database schema and the project builds you a browser UI and API with authentication, filtering, pagination, etc. Authorization is tricky though. I've been looking into high-level compile-to-SQL languages like TreSQL [1] for expressing more complex logic (e.g. `notes.get.require: notes.is_public OR (notes->organization.id = $user.id)`). There's some thinking to be done to flesh out a good language for expressing policies tied to a user session in SQL. [0] https://www.dbcore.org/ [1] https://github.com/mrumkovskis/tresql