querySQL
Canonical ID: data.query.
querySQL(sql, parameters)
Returns a list of maps with unique column names as keys. Use positional ? parameters. Maximum 1000 rows and 1 MiB; BLOBs and integers outside the exact 53-bit range are unsupported. Requires SQLite access.
Returns a Map with ok, status, value and error. Check ok before using value; denial or an unavailable host is a structured failure.
Requires Creator Pro or its technical trial for IDE/CLI run and build. Available on desktop, CLI and supported native exports; not in the public playground. Source remains editable in Learner. Generated apps have no Pliro licence check.
Call example
See the advanced application guide for declarations, explicit host permissions and complete examples. This call assumes the required permissions; handle means the value from a successful open operation.
querySQL("SELECT ? AS answer", [42])