Problems getting the correct Data out of my Database

Hey guys,

I have a problems getting Data out of my database reliably. I created some views to use aliases and make it a bit easier for the llm. Still I get inconsistencys.

Eg: I have 2 different tables that list sales and one that lists purchases. I created a workflow that identifies if the subject is a customer or supplier and hints the llm in that direction.

The problem I have now, is that I have a column for shipping receiver and name of the order creator for example. And a few other examples like this. How do I tackle this task? Even more static views for a given task to the point where I have 1 view per task?

Another problem is that it keeps searching for names without using a like operator. And in result I sometimes get no results cause of typos. Any ideas what I can do?