News for hackers. Stuff that matters.

A comment on We give every user SQL access to a shared ClickHouse cluster. Parent comment

Re:We give every user SQL access to a shared ClickHouse cluster by mattaitken on Saturday March 21, 2026 @10:05AM (#47467152)
You’re right RLS can go a long way here. With complex RBAC rules it can get tricky though.

The main advantages of a DSL are you can expose a nicer interface to users (table names, columns, virtual columns, automatic joins, query optimization).

We very intentionally kept the syntax as close to regular ClickHouse as possible but added some functions.

[ Parent | on HN ]
Re:We give every user SQL access to a shared ClickHouse cluster by theowaway213456 on Saturday March 21, 2026 @04:35PM (#47471018)
> table names, columns, virtual columns

This sounds solvable with clickhouse views?

> automatic joins

Is this also not solvable with views? Also, clickhouse heavily discourages joins so I wonder how often this winds up being beneficial? For us, we only ever join against tenant metadata (i.e. resolving ID to name)

> query optimization

This sounds potentially interesting - clickhouse's query optimizer is not great IME, but it's definitely getting better

[ Parent | on HN ]