I just purchased an SP sump pump. Should I hard plumb my aquarium or go with flexible hosing?

Fluval pumps include various fittings that allow you to consider both options. For the average hobbyist, we usually recommend flexible hosing as it has greater noise-dampening properties and requires less use of elbows and other fittings that can diminish pump output performance. It is also easier to replace, if necessary.