InfoPath Dev

I have a form that is connected with a database. In my DB I have records that contains the username of the user.

On load, the form has to load the information from the DB. That is working fine, now InfoPath load all the records.

But I only need the records of the current user.
How is it possible to do a query where I say that I only need the records where username = currentUser?
In InfoPath you can use username(), but how do I get it in my sql?

With in my sql, i mean: under Data > Data connections. modify the connection and click on "edit SQL"

We don't have dynamic SQL queries out of the box with InfoPath, unfortunately. Your options are writing code, building or buying a web service (DBXL, for example) or qRules also has commands for this.