Most syntax should work fine with either class. The exception are stored procedure calls which with wwADOSql require explicit parameter passing or parsing.
The following will work with wwSQL but not with wwADOSql:
oSQL.Execute("exec sp_NewId 'wws_tlineitems',?@pnId)
Instead Store Procedure calls should be made with Named parameters and a call to CallStoredProcedure:
oSQL.AddParameter('wws_LineItems','cTable')
oSQL.AddParameter(pnId,'pnID')
Specifically Stored Procedure calls with ADO require that you use the CallStoredProcedure