sql/ttl: automatically filter expired rows from SELECT queries on tables with TTL

select value from my_redis_tbl where key = $1 and expired_at > now();

The "and expired_at > now();" looks messy and this TTL capability appears incomplete since the core value-proposition is to eliminate these rows.

**Is your feature request related to a problem? Please describe.**
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

**Describe the solution you'd like**
A clear and concise description of what you want to happen.

**Describe alternatives you've considered**
A clear and concise description of any alternative solutions or features you've considered.

**Additional context**
Add any other context or screenshots about the feature request here.

Jira issue: CRDB-37294