Use on screen objects value as part of a SQL query to validate existence in DB.

Test Type: Keyword

Would it be at all possible to take the value of an on screen object and use it as part of a sql query to validate that the value also exists in the database.

For example;

A user creates a new store(shop) in a web based application, that store is assigned an ID.
The script captures that ID and then uses it as part of a query to validate existence in the database.

I would assume the process would be something like;
1) If Object
2) Set Variable Value
3) Database Table Check Point
- Written query

How would you tell the query to use the value of the variable from step 2?

Thanks.

P.S I found an old article from here: http://community.smartbear.com/t5/Getting-Started-with/How-to-use-a-variable-in-SQL-query-in-Keyword-Test/td-p/85415 which is from 2014, I believe someone else had a similar issue and it wasn't possible back then.