TIMESTAMPTZ instead of TIMESTAMP in goose_db_version?

[dank303]

I do see someone's suggested adding direct support for google sql (#618). Wondering if anyone else is looking into using spanner with its postgres dialect?

I'm trying to use openfga with google's spanner db (postgres dialect) and ran across this issue. I'm using pgadapter to allow DDL to be executed, but not all postgres types are supported.

In particular, the TIMESTAMP type used in goose_db_version is not supported, which causes the openfga migration to fail initially. I can work around this by creating that table prior to the initial migration, so I do have a path past this.

My question is: wouldn't a timestamp with timezone would be more appropriate here?