CAML Designer 2013 1.1.0.0

The functionality of this version of the tool is similar to what it offers you for SharePoint 2010:

You can build CAML queries for single lists
You can build queries that can be executed with SPSiteDataQuery
Beside the pure CAML queries, you can also get code snippets for the server-side object model, the .NET client-side object model, the JavaScript client-side object model and last but not least code snippets when working with REST.

Requires .NET 4.5 Framework to be installed upfront!