Support expressions in `partitionBy`

[dlindenkreuz]

db.selectFrom("orders").select((eb) =>
  eb.fn
    .sum("amount")
    .over((ob) =>
      ob
        .partitionBy([
          eb.fn.coalesce("category", "fallback_category") as any, // ← should not require any
        ])
        .orderBy("created_at")
    )
    .as("running_total")
);

Expected: partitionBy should accept ExpressionBuilder expressions, not just string column references.

Actual: TypeScript error unless as any is used. The overload only accepts StringReference. Generated SQL works nevertheless.

Playground Link: https://kyse.link/alT9M

[igalklebanov]

Hey 👋

Can you provide SQL spec proof this is needed?

[dlindenkreuz]

Sure thing.

• SQLite: https://sqlite.org/syntax/window-defn.html (PARTITION BY uses expr which is any expression)
• Postgres: https://www.postgresql.org/docs/18/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS

  Here, expression represents any value expression that does not itself contain window function calls.

• EDIT: MySQL: https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html

  Standard SQL requires PARTITION BY to be followed by column names only. A MySQL extension is to permit expressions, not just column names.

[aryanghugare]

can I tackle this ?
Please assign me this