[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();

[moonchild]

Linq is cool; I haven't really had opportunity to play with it as I'm not in the .net ecosystem. Another integrated language/database is kdb, although it borrows somewhat from sql's syntax.