That is not a homebrew sytax that Postgres came up with themselves.
replyIt's SQL/PGQ, which was derived from the Cypher language for Neo4J and now is part of the SQL standard.
Fair --- but I feel my criticism stands. It's awful. Don't get me started on 80% of all deployment uses of neo4j...
reply> [RLS]… planner goes haywire and does per-row-matching
replyEr… yes? It’s called Row-level security; how else are you going to validate that a row passes a policy?