TablePlus is a good example. I buy their product and in exchange I get a year of updates. After that, it keeps on working without new features or updates. If I want new features or updates after that, I buy it again. Otherwise, I can keep on using the version I have pretty much until it stops working due to e.g. platform changes.