Show HN: SnapQL – Desktop app to query Postgres with AI(github.com)

    SELECT: extract the columns that are named, optionally with an alias with AS (or simply a space)
    FROM: the [main] table to extract columns from
    [INNER] JOIN: an additional table to examine, returning only their intersection
    LEFT [OUTER] JOIN: an additional table to examine, returning everything in the LHS table, as well as any matches from the RHS table, with NULLs filling in missing data
    RIGHT [OUTER] JOIN: the same as LEFT JOIN, but with the logic swapped
    FULL [OUTER] JOIN: an additional table to examine, returning the union of both tables, regardless of matches
    ON: an expression to use for joining tables, generally consisting of at least one column from each table to match
    WHERE: a predicate (or series of predicates, with boolean operators joining them) to use for filtering the result set
    ORDER BY: one or more columns to order the result set by, in either ascending (ASC) or descending (DESC) order
    GROUP BY: one or more columns (though strictly speaking, this number must match the number of non-aggregated columns in the SELECT) to group the result set by
    LIMIT: a limit for the maximum number of rows returned