← Back to context

Comment by Planktonne

10 hours ago

This seems harder to read than SQL, and only less verbose if you assume that an SQL database would be built with Prela's limitations in mind, which doesn't feel like a reasonable assumption.

With some syntax sugar it looks almost exactly like SQL [1]. Here I’m showing the unsweetened edition for didactic purposes.

[1]: https://remy.wang/blog/prela.html

  • I think you'd want to format it like SQL blocks to separate various concepts and where data is coming from

        movie.with(
          company.s(country).eq("[us]"
        )
        .and(
          keyword.eq("character-name-in-title")
        )
        .select(
          title
          .and(
            cast.s(person).s(alias).s(text)
          )
        )