The whole code base uses naive date time and TIMESTAMP WITHOUT TIME ZONE.
Now there's conversion issues appearing in federation where timezones are not handled correctly.
Using NaiveDateTime is ......
Just sharing this particular merged PR in the Lemmy backend in case this affects Connect.