SQLite : get the files without extension from a column containing file names

I have a column (file_name) containing file names in the File table.

I want to get all the files without extension from the table with SQLite.

One way to do it is to select all file names except those with extension (I did not tried it yet) but I am wondering if there is a more straight forward way without using Set operators?

Thanks,