Return results of database command

Instead of using database import in a module to retrieve records I’m curious why running a database command like SELECT fieldname from table where fieldx = parameter doesn’t return a value - this would be an ideal way to do lookups. Or enhance the lookup function to query a remote database table based on input parameters

You can already do database lookups with the "Select matching database rows" action. Check it out.