I am working with Ignition writing to a MariaDb. I noticed that Ignition creates a table that stores the data with tagid column, rather than the tag name. Is there a way to have ignition create automatically create a column in the data table that has the tag name rather than the id.
No, and that would be an enormous performance killer. Learn to use JOINs if you need that in your own SQL. (Or better, don't write your own SQL against the historian. Use the provided scripting functions.)
The Ignition Database Table Reference | Ignition User Manual outlines the structure of the various tables. sqlth_te contains the id and tagPath.
One of the principles of good database design is that, as much as possible, each piece of information is stored only once. Look it up when required.