Is there an interface to code SQL logic?

[Profound Logic]

Question:
Is there an interface to code SQL logic?

Answer:
Yes. Some of the components like a drop down box, subfile grid, chart, etc. can be built entirely using SQL so that you don't have to code any RPG logic in your program to populate them. There is an interface in the Properties window that allows you to select the file and fields involved, and the platform will automatically build an SQL query to get your record set for the component.