How smart is SQLite at detecting column types from Csv data?

I once wrote a Python script to load csv files into SQLite. It had a whole hierarchy of rules to determine the data type of each column.