Accessing individual elements within a variable array

Quick question. I have an array of 5 assets [‘Pump 1’, ‘Pump 2’, ‘Pump 3’, ‘Pump 4’, ‘Pump 5’] which are part of the variable ${asset}. What I’d like to be able to do is access each of the selected assets individually.

In the database I’d use something like;

SELECT ARRAY[${asset}])[1]

Which gives me the first asset, and if were to try and get asset 6 (which doesn’t exist) then I’d get a null back (and would need to handle that in the dashboard metric).

Is it possible to access the elements directly without having to bounce them off the database?