How to Specify Yesterday in SQL. The SQL query language was designed to provide programmers with a way to create, maintain and modify databases in a structured way. Using SQL, the programmer can ...