Comment by nilamo

Comment by nilamo 2 days ago

I heavily disagree with the notion that most developers would rather query with something that isn't SQL.

kreetx 2 days ago

Funny, as Triplit front page shows a query much like SQL:

  const deliveredMessagesQuery = client
    .query("messages")
    .Where("conversationId", "=", convoId)
    .Order("created_at", "DESC")

[removed] a day ago

[deleted]

Reply View | 0 replies
blatantly 2 days ago

Well yeah choosing what to query, a filter and an order is at the heart of all query-like things. Buy SQL specifically is a text language not a fluent api.

Reply View | 0 replies
nilamo a day ago

Exactly. Hard to improve on something so great.
We love a
``` select {what} from {where} left join {where} on {how} where {why} ```
A simple query, concisely answering every relevant question, while hiding all of the details of how any of it works. Beautiful.

Reply View | 0 replies

Probably the biggest upgrade SQL could have is putting the SELECT after the FROM, so autocomplete would work nicely.