>>56994465The idea I had was actually even more busted.
https://en.wikipedia.org/wiki/Girardoni_air_rifleAllow me to introduce you to the Girandoni air rifle, the bane of gun control advocates everywhere. This motherfucker had a 20 round magazine in the 18th century and was fueled by a canister of pressurized air. While much quieter, the drawback of this weapon IRL was that each shot was weaker than the last due to depletion of the reservoir. Except since this is fantasy land, we can just have this be magical air, either from an Artificer or Wizard, which has consistent power. Now this is where it starts to get a bit OP.
Mage Hand is given for free to Arcane Tricksters as a cantrip, and RAW you're forced to take it in a slot, which essentially decreases the amount of cantrips you can have total by one. Except I'm buffing ATR (cause Archivist said it was outclassed by CoL Bard) to get this for free period, and you now have an extra cantrip. If my understanding of Mage Hand is correct, Alex can use this to cock the weapon after each shot without actually taking his hand off of the trigger, which essentially means that he is cheesing magic to have a semi-automatic firearm before modern bullets were even invented. Sadly, I don't think he can do this with his pistols, even though they are also repeating (each has a magazine of three), because he would need two Mage Hands in order to do it.