The present invention is directed to a method and apparatus of providing
programming assistance for an integrated development environment. In one
embodiment, a code portion is received. An attempt to retrieve a
structured query language (SQL) statement that corresponds with the line
code is then made. A recommendation based on the code portion for
restructuring the corresponding SQL statement is then generated. The
recommendation may include a modified SQL statement, referred to as a
recommended SQL statement or a textual spoken language recommendation.