SQL Recipes Pro

200+ SQL queries with explanations. Tap Run and see the result table right in the app. Add your own queries and browse offline. An everyday SQL cheat sheet, from your first SELECT to window functions. • 39 sections, including filtering, sorting, calculated fields, functions, GROUP BY, window functions, subqueries, JOIN, UNION, INSERT and UPDATE, data types, tables, views. • Changes by standard: 7 sections from SQL-92 to SQL:2023, with before-and-after queries. • Keyword and function reference: over 180 articles. Browse, search, or tap a word in a query to open its article. • Dialects compared: MySQL, PostgreSQL, SQLite, SQL Server, Oracle, Firebird, Access. Where they differ, the dialect-specific variants are shown. • Practice database: the classic MySQL “world” sample (countries, cities, spoken languages); its tables are described in the app. • Run in the app: more than half of the queries execute against the practice database, and the result table appears directly below the query. Requires an internet connection; up to 80 runs a day. • Search covers the queries themselves, not just titles: type a fragment you remember and find the query. • Edit any query and rerun the runnable ones; one tap brings the original back. • Add your own queries; they are saved in the app. • Everything except running queries works offline: queries, reference, search, favorites. • Easy on the eyes: light and dark themes, your choice of font and size, line numbers, and long lines that wrap instead of spilling off the screen. Queries are curated from professional sources and checked before release: the code works and is easy to follow. Built by a developer for developers. The CodePro project has been in active development since 2015.