I am currently working on building a model using ArcGIS ModelBuilder that will use the Make Query Layer tool with the Append tool. My intention is to have the results from a SQL Query export/append into a new GDB Table. Currently, I am doing this manually, but want to have a one-click model that will do it for me and eventually export the model out to a Python script that can be used outside of ArcGIS. I have have multiple Query Layers built outside of ModelBuilder, but want to combine all of the individual task(s) into one model. The problem is, when I run the model, it stops at the append tool saying the input is invalid and doesn't exist. I am sure someone has tried this and ran into this problem before and wondering if someone could give me some hints or ideas on how to make this work.