Symptoms
When creating an SQL based smartobject, only list methods are available.
Diagnoses
This is typically caused by a table not having a primary key set. It is important to note that a column with the "isIdentity" property does not qualify as a primary key.
Resolution
Upon inspecting the table schema, we found that while the isIdentity property was set, no primary key was defined. After altering the schema to add the primary key constraint for the column marked as isIdentity, and the issue was resolved.