If you store your data in the geodatabase using ST_Geometry spatial types, you can use SQL in addition to ArcGIS Desktop to work with your data. For example, you can use SQL to add records to an existing feature class or apply a definition query using SQL to display only features that meet specific criteria.
Specific examples of using SQL with existing feature classes can be seen in Workflow: Use SQL with existing feature classes.