Often when using the SQL on-premises actions such as query a table, query a view or execute a stored procedure you are only after a single record. Equally this applies to data sources and external data sources on forms.
Other connectors such as SharePoint Online and Azure AD support the 'First Item' result within the object.
Please add 'first item' support for the SQL on-premises actions and external data source variables.
Thank you very much for posting your feedback for our review. At this time, we will not be adding this request to the near-term backlog, as we are focused on other highly requested features. However, we reevaluate requests every quarter and will reach out if priorities change. Please keep the feedback coming as it is critical for our longer-term planning.