Alternative query building suggestion

[jtheisen]

Hi folks, this isn't a bug report but something the authors of node-sql may find useful.

I spent the last couple of weeks researching ways to get a good query syntax in TypeScript working - before I found this library.

I now have a proof of concept and a readme explaining what I found. In particular, there's a way to write queries like this:

processQuery(query(() => {
    const orderNoWithInvoiceCount = query(() => {
        const i = from(invoices);
        groupBy(i.orderNo);
        return { orderNo: i.orderNo, numberOfInvoices: count() }
    })
    const { orderNo, numberOfInvoices } = from(orderNoWithInvoiceCount)
    const latestInvoice = outerApply(query(() => {
        const i2 = from(invoices)
        where(i2.orderNo.eq(orderNo))
        orderByDesc(i2.createdAt)
        fetchOnly(1)
        return i2
    }))

    return { orderNo, numberOfInvoices, latestInvoice };
}))

So this ticket really is just an ad for a sort of blog post, but I the information is interesting for anyone involved with SQL query builders.