This is unfortunately not possible with the current version of SQL-LITE in CW. I updated the description since many users experience issues with boolean data type.

added more info, and link to specification data types

Fork

Added random test

An anti-pattern can create an error later on or cause technical debt. Which is why one should only select the columns that they need in a query. Where I disagree with this statment of using SELECT * as an anti-pattern in this instence is that Kata asked to "select all" which is literally what SELECT * means.

https://stackoverflow.com/questions/3138029/is-there-a-boolean-data-type-in-microsoft-sql-server-like-there-is-in-mysql

We have to SELECT all the rows (*) From Table_name
Put condition (WHERE....)
For shorting We use 'ORDER BY' Clause
For Descending order we have write 'DESC', By defaul it get in Ascending orer.

What is meant by this, "anti-pattern"?

The Note indeed does hint that the Values of the 'IsActive' is True / False, however Beginners such as myself have no way of knowing that we should use '1' instead of True when coding our solution. Please do clarify on that part! I believe it is valuable for Beginners to learn that True == 1, however without any hints to this I can see it being discouraging or potentially only further confusing people.

Note: IsActive (true or false) is misleading! Shoud be: Note: IsActive (1 or 0)

Булево значение цифрами? Вы что там курите?

More tests should be added to invalidate these two solutions ! -> 1 and 2

Kata hint != kata suggestion

Note: IsActive (1 or 0)