According to the specification, a ZIP file is a concatenation of the file data, some meta information per file, and an index containing metadata and the locations of the files inside the archive. It is possible to create ZIP archives using only T-SQL. Here is a POC.

Part of the metadata is a CRC32 code of each file – it can be calculated once per file and used in different zip archives.