Follow the below steps: 

1. From Studio, create a new Packaged Query. For the 'Physical data source to bind', select the data source you want to find the version. 
2. In the SQL tab, write "select version()". (without quotes). 
Save the packaged query. The Studio will show an error "Packaged queries must have exactly one OUT parameter that is a cursor with at least one column". 
3. Navigate to Parameters tab > click on button 'Design by Example'. It will add an output parameter into result CURSOR: "result CURSOR". Click ok and save the packaged query. 

Screenshot for reference:



5. Execute the Packaged Query and it will display the version string like the example below: 
version: PostgreSQL 12.8, compiled by Visual C++ build 1929, 64-bit

Screenshot for reference:



Note: This will only be applicable for databases that support 'select version()' query sent against them.