Had the M2 Lora in an ammo can with the m2, lead acid battery and solar charge controller. Connected about 5ft of rg58 coax wound up in there plus another 5 making its way out to a 915mhz high gain fibreglass antenna. Had zero issues with this setup except better transmitting distance.
Also remote mounted the Emlid Lora antenna on the Tractor through about 6ft of that really thin coax for cellphone, still no issue.
15-20ft would be the max i go with such small wattage with the thin cable usually attached rg316?
You will get some losses no matter what. If you have the wallet size to get some LMR240 cable you will lose next to nothing over 100 feet. at about $11cdn per foot with sma connectors
This is a choice bound more by the loss characteristics of the cable than the connector type.
I think you should experiment and have fun!