QQ: is there any way to have materialization of software defined assets marked as stale after x-hours or x-days since the last materialization?

I believe "freshness policy" is what you should look for in docs

Yep, that solves it