Ability for search keyword to match multiple Search Attribute/Columns in Database Picker Script Field

Currently, the Database Picker Script Field Search Attribute only accepts one attribute.

As a user,
I need to be able to search a Database Picker Script Field with a keyword that matches multiple Search Attributes/Column.
So that I can return all entries (usually names) which match my search term across multiple attributes.

Sample Use Case

I have a database with the following columns
Project table:
ID, Pname, Pkey, ProjectType

For example table:

Now, when I set the Search attribute to pname and search the field with the keyword 'Scrum', my search result would return 1 scrum project. 

Once this feature request is implemented, it should be possible to set multiple attributes/columns as the search attribute. For example, when I set the Search attribute to be pname and Ptype I should be able to search using project name and project type*.*