RunQuery() uses sqldf() to perform its SQL queries, but it currently does not enforce classes when returning data. Using the "name__class" method allows the user to specify the class of the column in the query, and sqldf will return the data in the proper class.
When a spec entry contains "type", we should use that field to ensure class compliance throughout the mapping process.
Feature Details
RunQuery()usessqldf()to perform its SQL queries, but it currently does not enforce classes when returning data. Using the "name__class" method allows the user to specify the class of the column in the query, andsqldfwill return the data in the proper class.When a
specentry contains "type", we should use that field to ensure class compliance throughout the mapping process.Example Code
Possible Implementation
Additional Comments