Lose Dropdown properties in Native Query

hello, I'm having issue that when I use native query I lose the dropdown of a table field, but if I ask my question through GUI and then apply that filter in the dashboard, if I get the dropdown I need. any idea of how to solve this? Or is there a way to see the query that it sends once I apply a filter to a dashboard? thanks in advance!

Hi @franpuebla
Post "Diagnostic Info" from Admin > Troubleshooting.
So which type of filter are you using?
Have a look here: https://www.metabase.com/docs/latest/troubleshooting-guide/filters.html#are-you-seeing-a-different-kind-of-input-widget-than-you-expected

You will have to look in your database query log if you are trying to debug something.