repo-add does not create empty database

When trying to create a local package repo I notice repo-add refused to create a new empty database. Confused, I tried to read the script but repo-add is apparently a binary file. Even more confused now, I then try installing core/pacman and found that repo-add works as expected, creates the new empty database file, and is a readable script and not a binary file. If repo-add is not created from [scripts/repo-add.sh.in](https://github.com/CachyOS/pacman/blob/master/scripts/repo-add.sh.in) then what even is this binary file? Where did it come from?