Which query and loader setup correctly filters active users assuming the table is users with a boolean column is_active?
hard📝 Application Q15 of 15
LangChain - Document Loading
You want to load only active users from a database using Langchain's SQLDatabaseLoader. Which query and loader setup correctly filters active users assuming the table is users with a boolean column is_active?
Aloader = SQLDatabaseLoader(uri='sqlite:///app.db', query='SELECT * FROM users WHERE is_active = 1')
Bloader = SQLDatabaseLoader(uri='sqlite:///app.db', query='SELECT * FROM users WHERE is_active')
Cloader = SQLDatabaseLoader(uri='sqlite:///app.db', query='SELECT * FROM users WHERE is_active = 'true'')
Dloader = SQLDatabaseLoader(uri='sqlite:///app.db', query='SELECT * FROM users WHERE active = true')
Step-by-Step Solution
Solution:
Step 1: Understand SQL boolean filtering in SQLite
SQLite uses 1 for true and 0 for false in boolean columns.
Step 2: Evaluate each query for correctness
loader = SQLDatabaseLoader(uri='sqlite:///app.db', query='SELECT * FROM users WHERE is_active = 1') correctly uses 'is_active = 1'. loader = SQLDatabaseLoader(uri='sqlite:///app.db', query='SELECT * FROM users WHERE is_active') is incomplete, C has wrong quotes, D uses wrong column name.
Final Answer:
loader = SQLDatabaseLoader(uri='sqlite:///app.db', query='SELECT * FROM users WHERE is_active = 1') -> Option A
Quick Check:
Boolean true in SQLite = 1 [OK]
Quick Trick:Use 'is_active = 1' for true in SQLite queries [OK]
Common Mistakes:
Using wrong column name 'active'
Incorrect SQL syntax for boolean values
Missing comparison operator in WHERE clause
Master "Document Loading" in LangChain
9 interactive learning modes - each teaches the same concept differently
