SQL: Querying Microsoft Great Plains - Overview for Database Administrator/Developer

Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it.  Now it is targeted to the whole spectrum of horizontal and vertical market clientele.  Small companies use Small Business Manager (which is based on the same technology - Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations.  There are several reporting tools available and you definitely need to know which one to use for different types of reports.