InfluxDB's INTO query can turn tags into fields by default, which may lead to unexpected behavior if not handled properly, such as losing the ability to group by those tags in the new retention policy. To avoid this, it's recommended to include GROUP BY * in INTO queries to preserve all original tags as tags in the destination data. Additionally, InfluxDB's ELAPSED() function can be used to query data based on time intervals, but specifying a unit greater than the difference between timestamps returns 0, which may not produce the desired results if not handled correctly.