Hi.
gz file is compressed archive. sql file is plain text file- dump of Your database. You can restore Your database using sql file simply.
See documentation of Immich:
And take time to explore pg_restore command, or using Adminer (available from AppStore) for access Your database.