Fig. 3.

An example of stage 4 from Fig. 2 showing the logic needed to generate the SQL for a date constraint. This is conditionally based on the query definition’s values for the “to” and “from” of the date constraint received from the user interface; for example, if both values are present, a between clause is needed. This returns a SQL clause comparing “start_date”, which is found in the source database table.