Free API for Weather Queries?

Is there a free/open API for querying weather data, such that SQL-like or LINQ-like queries can be made?