We've given some love to the delimited text data provider in 3.24, with several enhancements which include:
Boolean type support and automatic detection
Boolean data types are now first-class citizens, which are automatically recognized when all records in a column contain one of the following values (case insensitive):
Boolean fields are also detected from a CSVT file, a GDAL/GeoCSV format e.g.
Integer(Boolean)
You can also add custom string representations for TRUE/FALSE (for example a localized "yes"/"no" value).
Column type override
Column types are automatically determined (by an initial limited scan of the file for immediate feedback followed by a full scan of the file which happens in a separate thread to not block the GUI and is user-interruptible), the types are exposed to the GUI as combo boxes and the user can override the automatically determined types.
Enhanced CSVT support.
CoordX, CoordY, Point(X/Y), WKT are now recognized as specified in https://giswiki.hsr.ch/GeoCSV
This feature was funded by Stadt Freiburg im Breisgau
This feature was developed by Alessandro Pasotti