I rewrote PostHog's SQL parser, 70x faster, while barely looking at the code

Re:I rewrote PostHog's SQL parser, 70x faster, while barely ... by spinachsalad on Thursday June 25, 2026 @11:26AM (#48674848)

> there’s a test for SELECT SELECT FROM FROM WHERE WHERE AND AND which is completely valid SQL

Is this even true? I tried it in SQLite and there's a syntax error after first SELECT. It would work when "SELECT", "FROM" etc. are quoted, but that's not the same thing.

[ Parent | on HN ]

Re:I rewrote PostHog's SQL parser, 70x faster, while barely ... by charlieflowers on Thursday June 25, 2026 @12:56PM (#48676204)

I interpreted it as referring to a table named "FROM" and fields named "SELECT", "WHERE" and "AND".

[ Parent | on HN ]