Add support for pglite

This almost works. It's very good. But there's still an array encoding issue that breaks events right now, unfortunately. This needs to be fixed on the pglite side.