RBAC is a hard requirement for many operational data products. In Materialize, we implemented it following Postgres patterns to make it as predictable as possible.
MZ Engineer @joekosh44 wrote about it here: https://t.co/PB2X5cJrSO
From the article, a tangential side-effect of syntax consistency:
One of our engineers @joekosh44 found a bug in PostgreSQL when verifying SQL between MZ and PG, he contributed the fix and it's included in PG15!
.@joekosh44 was one of our best graduating @CMUDB students last semester. In less than two months, he joined @MaterializeInc and turned out a #Postgres patch on the street that just got approved + merged: https://t.co/seoUslwyOH