An append only audit trail would also have to carry some type information, since tables can change shape. It makes the relationship to ordinary relational query

An append only audit trail would also have to carry some type information, since tables can change shape. It makes the relationship to ordinary relational querying interesting, to say the least. Postgres's logical replication slots do provide way to implement your own change streaming.