timestamp
-like field can be used to create a Timescale hypertable.
You can also use the traditional JDBC/postgres sink with Timecale - you would just need to create the hypertable yourself.
You use TimescaleDB for anything you would use PostgreSQL for, including directly serving APIs and other simple indexed table look-ups. With Timescale Hypertables, you can also make complex database queries like time-windowed aggregations, continuous group-bys, and more.
Learn more about Timescale here: https://docs.timescale.com/api/latest/