Is it possible to take input from a file in NotesSQL

First you have to read the list, either using normal file input (txt) or the COM interface (xls). Then you can assemble your query as a string. Assuming that's what you want...

But why do you use NotesSQL? Can you explain?

Notes SQL to extract data from Notes DB.  We are working for a migration project. So we have to extract all the data from Lotus DB. We use Lotus Scripts to extract any files if present and NoteSQL to extract the fields and values.

First you have to read the list - is it possible using NotesSQL?

Oh... migration... how sad, and what a waste of time and money. Just stay on Notes, upgrade if need be, it's far more reliable.

Extracting data can be done in many ways, of which NotesSQL is one of the worst. Better export everything to data files and folders, or directly into the new environment using LotusScript and COM. You can also use one of the Connectors to connect directly to an SQL server database, all from LotusScript.

Extracting data can be done in many ways, of which NotesSQL is one of the worst - I agree but I cannot change my company's decision.

You can also use one of the Connectors to connect directly to an SQL server database, all from LotusScript - Can you please give, little more explanation on this?

So if the company decides to move to COBOL, you follow? ;-)

Here an example of how to connect to SQL Server:
https://www.experts-exchange.com/questions/27302209/Access-SQL-Server-database-from-Lotus-Notes-using-lsxlc.html

Do you think I can say No :P :) :)

Thank you... I will go through your example

Yes you can!     :D