Comment by Luuseens

What you described sounds a lot like .NET's LINQ, which translates to SQL queries as well:

    teachers.Where(t => t.Age > 30).Count();