Hi Michael,

Thank you for reporting this.

As far as I know, this is the plugin's default behavior when attempting to "guess" the correct data type. It does so by analyzing the first several rows of each column as they come from the data source.

Currently, there is no built-in way to change this.

However, I will check with our QA team to confirm and conduct additional testing to ensure accuracy.

 

2. Regarding manually pre-determining each column's data type before table generation:

This is only possible for Manual Tables. When you create a new manual table, it generates a standalone SQL table in the database with its own set of columns and rows.

As a result, you can define each column type in advance, which determines how the fields are created in the database.

 

On the other hand, for other table types—such as SQL Query-based tables—our plugin simply pulls the data and tries to "guess" the correct data type, as mentioned earlier.

 

We’ll follow up as soon as we have additional insights.

Hi Michael,

Thank you for sharing your feedback. I completely understand your frustration, and I appreciate your detailed input on how our SQL parser handles column type detection.

 

As mentioned, our SQL feature is designed as a custom PHP & SQL parser, which inherently has certain limitations. Unlike a full-fledged database management system, it uses an internal logic to determine column types based on the first few rows of data.

 

As you pointed out, factors such as NULL values, header formats, and data patterns influence how the parser interprets each column.

I’ve forwarded your concerns to our development team and management for review.

 

I’ll also check if our developers can provide more insights into how the current logic works and whether improvements can be made.

I can't promise anything, but if one of our developers finds the time soon to provide more details on how that part of our parser logic works, I will report back and share them with you.

 

If you have specific suggestions on how this process/logic could be improved, I encourage you to submit a feature request on our suggestions page.
If a similar request already exists, you can upvote it to help prioritize it for future development.

Additionally, you can stay updated on any changes, bug fixes, or new features through our changeLog page, (also available in the plugin dashboard), or by subscribing to our newsletter.

Thanks again.