Example the cases with .sql.gz or .sql.bz2 extension you will some chars on terminal which will eventually crash terminal, however there are no problems when source is just plane .sql files.
target path | | Location, on the remote host, of the dump file to read from or write to.Uncompressed SQL files (.sql) as well as bzip2 (.bz2), gzip (.gz) and xz (Added in 2.0) compressed files are supported.
https://github.com/bertvv/ansible-role-mariadb/blob/a08fb33e7e74e2cbfb62f7bbabdba6597de4dc27/tasks/databases.yml#L31
Example the cases with .sql.gz or .sql.bz2 extension you will some chars on terminal which will eventually crash terminal, however there are no problems when source is just plane .sql files.
https://docs.ansible.com/ansible/latest/collections/community/mysql/mysql_db_module.html