ó
    Ñ]jNŸ  ã                  óð  • S SK Jr  S SKJr  S SKrS SKrS SKrS SKJr  S SKJ	r	  S SKJ
r
  S SKJr  S SKJr  S SKJr  S S	KJr  S S
KJr  S SKJr  S SKJr  S SKJr  S SKJr  S SKJr  S SKJr  S SKJr  S SKJr  SSKJr  SSKJr  SSKJr  SSKJr  SSKJr  SSK J!r!  SSKJ"r"  SSKJ#r#  SSKJ$r$  SSKJ%r%  SSK&J'r'  \R*                  (       aœ  SS KJ(r(  SS!KJ)r)  SS"KJ*r*  SS#KJ+r+  SS$KJ,r,  SS%KJ-r-  SS&KJ.r.  SS'KJ/r/  SS(KJ0r0  SS)KJ1r1  SS*K2J3r3  SS+K(J4r4  SS,K(J5r5  SS-K(J6r6  SS.K(J7r7  SS/K(J8r8  SS0K(J9r9  SS1K(J:r:  SS2K*J;r;  SS3K+J<r<  SS4K+J=r=  SS5K+J>r>  SS6K+J?r?  SS7K+J@r@  SS8K+JArA  SS9KJBrB  \" S:\R†                  S;9rD\" S<\	S=\4   S;9rE\" S>\RŒ                  S;9rG\" S?\S;9rHS·S@ jrISA rJ        S¸SB jrK        S¹SC jrL\        SºSD j5       rM\S=SE.         S»SF jj5       rM\        S¼SG j5       rM\        S½SH j5       rM\        S¾SI j5       rM\        S¿SJ j5       rM\        SÀSK j5       rM\        SÁSL j5       rM\        SÂSM j5       rM\        SÃSN j5       rM\        SÄSO j5       rM\        SÅSP j5       rM\        SÆSQ j5       rM\S=SR.         SÇSS jj5       rM\        SÈST j5       rM\        SÉSU j5       rM\        SÊSV j5       rMSSSWSWSX.               SËSY jjrM        SÌSZ jrN      SÍS[ jrO " S\ S]5      rP " S^ S_5      rQ " S` Sa5      rR " Sb Sc\P5      rS " Sd Se\P5      rTS\#Rª                  SS4           SÎSf jjrV " Sg Sh\P5      rW " Si Sj\P5      rX " Sk Sl\P5      rY " Sm Sn\P5      rZ " So Sp\P5      r[ " Sq Sr\P5      r\ " Ss St\T\P5      r] " Su Sv\]\P5      r^ " Sw Sx\P5      r_ " Sy Sz\T\P5      r` " S{ S|\X\T\P5      ra " S} S~\X\P5      rb " S S€\W\P5      rc " S� S‚\S\P5      rd " Sƒ S„\X\P5      re " S… S†\X\T\P\RÌ                  5      rg " S‡ Sˆ\g\P5      rh " S‰ SŠ\g\P5      ri " S‹ SŒ\S\P5      rj " S� SŽ\P5      rk " S� S�\R\P5      rl " S‘ S’\Q\X\P5      rm " S“ S”\Q\S\P5      rn " S• S–\n5      ro " S— S˜\P5      rp " S™ Sš\]5      rq " S› Sœ\Z\X\P5      rr " S� Sž\P5      rs " SŸ S \X\P5      rt " S¡ S¢\W\P5      ru " S£ S¤\s5      rv " S¥ S¦\P5      rw " S§ S¨\P5      rx " S© Sª\Z\W\P5      ry " S« S¬\y5      rz " S­ S®\z5      r{ " S¯ S°\Z\W\P5      r| " S± S²\W\P5      r} " S³ S´\W\P5      r~0 r\€" \5       HZ  r�\‚" \\�5      rƒ\�GR	                  Sµ5      (       d  M%  \�GR                  SµS¶5      r�\�\†" 5       ;   d  ME  \†" 5       \�   " \ƒ5      r‡\‡\\ƒ'   M\     \(       d1  \\GR                     r‰\Š\‹\Œ\�4 H  rŽ\‰\\GR                  \Ž   '   M     gg)Ïé    )ÚannotationsN)ÚAny)ÚCallable)Úcast)ÚDict)ÚIterable)ÚIterator)ÚList)ÚNoReturn)ÚOptional)Úoverload)ÚSequence)ÚTuple)ÚType)ÚTYPE_CHECKING)ÚTypeVar)ÚUnioné   )Úroles)Úvisitors)Úis_from_clause)ÚExecutableOption)ÚOptions)ÚHasCacheKey)Ú	Visitableé   )Úexc)Ú
inspection)Úutil)ÚLiteral)Úelements)Úlambdas)Úschema)Ú
selectable)Ú_ColumnExpressionArgument)Ú_ColumnsClauseArgument)Ú_DDLColumnArgument)Ú_DMLTableArgument)Ú_FromClauseArgument)Ú_OnlyColumnArgument)Ú_DMLTableElement)ÚBindParameter)ÚClauseElement)ÚColumnClause)ÚColumnElement)ÚNamedColumn)ÚSQLCoreOperations)Ú
TextClause)ÚColumn)Ú_ColumnsClauseElement)Ú_JoinTargetProtocol)Ú
FromClause)ÚHasCTE)Ú
SelectBase)ÚSubquery)Ú_TraverseCallableTypeÚ_SR)ÚboundÚ_F.Ú_StringOnlyRÚ_Tc                ó|   • [        U [        [        R                  45      (       + =(       a    [	        U S5      (       + $ )z`Return whether or not the element is a "literal" in the context
of a SQL expression construct.

Ú__clause_element__)Ú
isinstancer   r#   ÚSchemaEventTargetÚhasattr)Úelements    ÚU/home/mande/repo/quber/.venv/lib/python3.13/site-packages/sqlalchemy/sql/coercions.pyÚ_is_literalrG   O   s<   € ô ØÜ	”F×,Ñ,Ð-óô ÷ 5ô �gÐ3Ó4Ô
4ð5ó    c                óÒ  • [        U [        R                  5      (       a1  [        U [        5      (       d  U  H  n[	        U5      (       a  M    g   g[        U [
        [        R                  [        [        [        R                  R                  45      (       + =(       aI    [        U S5      (       + =(       a1    [        U [        5      (       + =(       d    [        U [        5      (       + $ )a  Return whether or not the element is a "literal" in the context
of a SQL expression construct.

does a deeper more esoteric check than _is_literal.   is used
for lambda elements that have to distinguish values that would
be bound vs. not without any context.

FTrA   )rB   Úcollections_abcr   ÚstrÚ_deep_is_literalr   r#   rC   r   r   r   ÚlanghelpersÚsymbolrD   ÚtypeÚ
issubclass)rE   Úelems     rF   rL   rL   [   s¿   € ô �'œ?×3Ñ3×4Ñ4¼ZØ”÷>ñ >ó ˆDÜ# D×)Ó)Ùñ ð ô ØäÜ×(Ñ(ÜÜÜ× Ñ ×'Ñ'ðó	
ô 		
÷ 	
ô ˜Ð!5Ó6Ô6÷	
ô ˜7¤DÓ)Ô)÷ 4Ü˜g¤{Ó3Ô3ðrH   c                óB   • [         R                  " U SU< SU< S35      $ )Nz.. warning:: The z argument to z¤ can be passed as a Python string argument, which will be treated as **trusted SQL text** and rendered as given.  **DO NOT PASS UNTRUSTED INPUT TO THIS PARAMETER**.)r   Úadd_parameter_text)Ú	paramnameÚmeth_rstÚ	param_rsts      rF   Ú_document_text_coercionrW   �   s&   € ô ×"Ò"Ùó “hð	 ó
ð 
rH   c                ó  • U(       av  [        US   [        [        [        45      (       aS  [	        U5      S:X  aD  [        US   [        5      (       a  [
        R                  " SU  SU S35      e[        SUS   5      $ [        SU5      $ )Nr   r   zThe "z" argument to zt(), when referring to a sequence of items, is now passed as a series of positional elements, rather than as a list. úSequence[_T])rB   ÚlistÚsetÚdictÚlenr   ÚArgumentErrorr   )ÚattrnameÚfnnameÚargss      rF   Ú!_expression_collection_was_a_listrb   ‘   sƒ   € ö
 ”
˜4 ™7¤T¬3´Ð$5×6Ñ6¼3¸t»9È»>Ü�d˜1‘gœt×$Ñ$Ü×#Ò#Ø˜�z °¨xð 84ð 4óð ô �N D¨¡GÓ,Ð,ä� Ó%Ð%rH   c                ó   • g ©N© ©ÚrolerE   Úkws      rF   Úexpectri   £   ó   € ð
 rH   ©Úas_keyc               ó   • g rd   re   )rg   rE   rl   rh   s       rF   ri   ri   «   s   € ð rH   c                ó   • g rd   re   rf   s      rF   ri   ri   µ   s   € ð
 rH   c                ó   • g rd   re   rf   s      rF   ri   ri   ½   ó   € ð
 "rH   c                ó   • g rd   re   rf   s      rF   ri   ri   Å   rp   rH   c                ó   • g rd   re   rf   s      rF   ri   ri   Í   s   € ð
 -0rH   c                ó   • g rd   re   rf   s      rF   ri   ri   Õ   s   € ð
 rH   c                ó   • g rd   re   rf   s      rF   ri   ri   Ý   s   € ð rH   c                ó   • g rd   re   rf   s      rF   ri   ri   é   s   € ð rH   c                ó   • g rd   re   rf   s      rF   ri   ri   ÷   s   € ð
 rH   c                ó   • g rd   re   rf   s      rF   ri   ri   ÿ   s   € ð
 rH   c                ó   • g rd   re   rf   s      rF   ri   ri     ó   € ð
 rH   c                ó   • g rd   re   rf   s      rF   ri   ri     ry   rH   )Úexplicit_subqueryc               ó   • g rd   re   )rg   rE   r{   rh   s       rF   ri   ri     s   € ð rH   c                ó   • g rd   re   rf   s      rF   ri   ri   !  s   € ð
  rH   c                ó   • g rd   re   rf   s      rF   ri   ri   )  s   € ð
 rH   c                ó   • g rd   re   rf   s      rF   ri   ri   2  rj   rH   F)Úapply_propagate_attrsÚargnameÚpost_inspectÚdisable_inspectionc          	     óô  • U R                   (       aL  [        U5      (       a<  [        US5      (       a+  [        R                  " UU [        R
                  " S0 UD6US9$ [        U    nUn[        U[        R                  [        R                  [        R                  [        R                  45      (       Gd"  S n	UR                  (       a  UR                  " U40 UD6n	GO.UnSn
UR                   (       a$  [        X5      (       a  [        US5      (       a  Sn
OJ[        US5      (       a9  Sn
[#        USS5      (       d  UR%                  5       nOO[        US5      (       a  M9  U
(       dm  UR&                  (       aC  U(       d<  [(        R*                  " USS9nUb$  U(       a  UR,                     UR%                  5       n	U	c  UR                  " U4SU0UD6n	O7Un	O4[        U[        R                  5      (       a  UR2                  " S0 UD6n	OUn	Ubf  [4        R6                  (       a  [        U	[8        [:        45      (       d   eUR<                  (       d#  [#        U	S	S 5      (       a  U	R<                  Ul        UR>                  U	R@                  RB                  ;   a)  URD                  (       a  URD                  " U	4UUS
.UD6n	U	$ URF                  " X‰4SU0UD6$ ! [.         a    UR1                  Xƒ5         GN9f = f)NÚ__code__)r€   FrA   TÚis_clause_element)Úraiseerrr�   Ú_propagate_attrs)r�   Úoriginal_elementre   )$Úallows_lambdaÚcallablerD   r"   ÚLambdaElementÚLambdaOptionsÚ_impl_lookuprB   r!   ÚCompilerElementr#   Ú
SchemaItemÚFetchedValueÚ	PyWrapperÚ_resolve_literal_onlyÚ_literal_coercionÚ$_skip_clauseelement_for_target_matchÚgetattrrA   Ú_use_inspectionr   ÚinspectÚ_post_inspectÚAttributeErrorÚ_raise_for_expectedÚ_sa__py_wrapper_literalÚtypingr   r1   r-   rˆ   Ú_role_classÚ	__class__Ú__mro__Ú_post_coercionÚ_implicit_coercions)rg   rE   r€   r�   r‚   rƒ   rh   Úimplr‰   Úresolvedr†   Úinsps               rF   ri   ri   :  s×  € ð 	××ô
 �W×ÑÜ�G˜Z×(Ñ(ä×$Ò$ØØÜ×!Ò!Ñ' BÑ'Ø"7ñ	
ð 	
ô ˜Ñ€DàÐäØä×$Ñ$Ü×ÑÜ×ÑÜ×Ñð		
÷ò ð ˆà×%×%Ø×-Ò-¨gÑ<¸Ñ<ŠHà&Ðà %Ðð ×9×9Ü˜w×-Ñ-Ü˜GÐ%9×:Ñ:à$(Ñ!ä˜gÐ';×<Ñ<Ø(,Ð%ä" 7Ð,?À×GÑGØ")×"<Ñ"<Ó">™àô ˜gÐ';×<Ó<ö %Ø×'×'Ö0BÜ%×-Ò-¨gÀÑF�DØÑ'Þ'Ø ×.Ò.ðPØ'+×'>Ñ'>Ó'@˜Hð Ñ#Ø#×5Ò5Øñ Ø)0ð Ø46ñ �Høð #‘Ü	�GœW×.Ñ.×	/Ñ	/Ø×2Ò2Ñ8°RÑ8‰àˆàÑ(Ü××Ü˜hÔ):¼MÐ(J×KÑKÐKÐKà$×5×5¼'ØÐ(¨$÷;
ñ ;
ð 6>×5NÑ5NÐ!Ô2à×Ñ˜8×-Ñ-×5Ñ5Ó5Ø××Ø×*Ò*ØðàØ!1ñð ñ	ˆHð ˆà×'Ò'Øñ
Ø07ð
Ø;=ñ
ð 	
øôC  .ó PØ ×4Ñ4Ð5E×OðPús   Æ-K ËK7Ë6K7c                óB   • UR                  SS 5        [        X4SS0UD6$ )Nrl   T)Úpopri   rf   s      rF   Úexpect_as_keyr¨   ®  s'   € ð ‡F�Fˆ8�TÔÜ�$Ñ3¨Ð3°Ñ3Ð3rH   c              #  ó  #   • U Hƒ  nS nS n[        X5      n[        U[        5      (       a  [        U[        5      (       d   eU=p5O4/ nUR                  n[        R
                  " U0 SU05        U(       a  US   nUb  UOUnXTX84v •  M…     g 7f)NÚcolumnr   )ri   rB   rK   Úappendr   Útraverse)	rg   ÚexpressionsÚexprÚstrnamerª   r¤   ÚcolsÚ
col_appendÚadd_elements	            rF   Ú expect_col_expression_collectionr³   µ  s—   é € ó ˆØˆØˆä,2°4Ó,>ˆÜ�h¤×$Ñ$Ü˜d¤C×(Ñ(Ð(Ð(Ø!%Ð%ˆG�hà&(ˆDØ=A¿[¹[ˆJÜ×Ò˜h¨¨X°zÐ,BÔCÞØ˜a™�Ø &Ñ 2‘f¸ˆà Ð4Ô4ò! ùs   ‚BBc                  óš   • \ rS rSr% SrS rSrS\S'   SrSr	S r
 S         SS	 jjr  SSSSS
.               SS jjjrSrg)ÚRoleImpliÓ  )rž   Únamer—   c                ó   • [        5       erd   )ÚNotImplementedError©ÚselfrE   rh   s      rF   r”   ÚRoleImpl._literal_coercionÖ  s   € Ü!Ó#Ð#rH   Nr   r¡   Fc                óp   • Xl         UR                  U l        [        U[        R
                  5      U l        g rd   )rž   Ú
_role_namer¶   rP   r   ÚUsesInspectionr—   )rº   Ú
role_classs     rF   Ú__init__ÚRoleImpl.__init__Ý  s*   € Ø%ÔØ×)Ñ)ˆŒ	Ü)¨*´e×6JÑ6JÓKˆÕrH   c                ó(   • U R                  XU5        g rd   ©r›   ©rº   rE   r¤   r�   rh   s        rF   r¢   ÚRoleImpl._implicit_coercionsâ  s   € ð 	× Ñ  °8Õ<rH   ©ÚadviceÚcodeÚerrc               óì   • Ub  X1La  U< SU< S3nO[        U5      nU(       a  U R                  < SU< SU< S3n	OU R                  < SU< S3n	U(       a  U	SU-   -  n	[        R                  " X•S9Ue)	Nz object resolved from z objectz expected for argument z; got Ú.z expected, got Ú )rÈ   )Úreprr¶   r   r^   )
rº   rE   r�   r¤   rÇ   rÈ   rÉ   rh   ÚgotÚmsgs
             rF   r›   ÚRoleImpl._raise_for_expectedë  sm   € ð Ñ HÒ$;Û9AÃ7ÐK‰Cä�w“-ˆCæà—	”	ÛÛð‰Cð -1¯I¬I³sÐ;ˆCæØ�3˜‘<ÑˆCä×Ò Ñ/°SÐ8rH   )rž   r—   r¶   rd   ©
rE   r   r¤   r   r�   úOptional[str]rh   r   Úreturnr   ©NN©rE   r   r�   rÒ   r¤   zOptional[Any]rÇ   rÒ   rÈ   rÒ   rÉ   úOptional[Exception]rh   r   rÓ   r   )Ú__name__Ú
__module__Ú__qualname__Ú__firstlineno__Ú	__slots__r”   r¡   Ú__annotations__r“   r•   rÀ   r¢   r›   Ú__static_attributes__re   rH   rF   rµ   rµ   Ó  sÔ   ‡ Ø:€Iò$ð €N�CÓØ!ÐØ+0Ð(òLð "&ð	=àð=ð ð=ð ð	=ð
 ð=ð 
õ=ð "&Ø"&ð	9ð !%Ø"Ø#'ñ9àð9ð ð9ð  ð	9ð ð9ð ð9ð !ð9ð ð9ð 
÷9ñ 9rH   rµ   c                  ó   • \ rS rSrSrS rSrg)Ú_Deannotatei
  re   c                ó   • SSK Jn  U" U5      $ )Nr   )Ú_deep_deannotate)r   rá   )rº   r¤   rh   rá   s       rF   r¡   Ú_Deannotate._post_coercion  s   € Ý*á Ó)Ð)rH   N©r×   rØ   rÙ   rÚ   rÛ   r¡   rÝ   re   rH   rF   rß   rß   
  s   † Ø€Iõ*rH   rß   c                  ó   • \ rS rSrSrSrSrg)Ú_StringOnlyi  re   TN)r×   rØ   rÙ   rÚ   rÛ   r“   rÝ   re   rH   rF   rå   rå     s   † Ø€Ià ÓrH   rå   c                  ó(   • \ rS rSrSrSS jrS rSrg)Ú_ReturnsStringKeyi  re   Nc                óV   • [        U[        5      (       a  U$ U R                  XU5        g rd   ©rB   rK   r›   rÄ   s        rF   r¢   Ú%_ReturnsStringKey._implicit_coercions  s$   € Ü�gœs×#Ñ#ØˆNà×$Ñ$ W°xÕ@rH   c                ó   • U$ rd   re   r¹   s      rF   r”   Ú#_ReturnsStringKey._literal_coercion"  ó   € ØˆrH   rd   ©r×   rØ   rÙ   rÚ   rÛ   r¢   r”   rÝ   re   rH   rF   rç   rç     s   † Ø€IôAõrH   rç   c                  ó(   • \ rS rSrSrS rSS jrSrg)Ú_ColumnCoercionsi&  re   c                ó0   • [         R                  " S5        g )Nz|implicitly coercing SELECT object to scalar subquery; please use the .scalar_subquery() method to produce a scalar subquery.)r   Úwarn)rº   s    rF   Ú"_warn_for_scalar_subquery_coercionÚ3_ColumnCoercions._warn_for_scalar_subquery_coercion)  s   € Ü�	Š	ðõ	
rH   Nc                óè  • Un[        USS5      (       d  U R                  XSU5        g UR                  (       a   U R                  5         UR	                  5       $ UR
                  (       aI  [        U[        R                  5      (       a*  U R                  5         UR                  R	                  5       $ U R                  R                  (       a  UR                  (       a  U$ U R                  XSU5        g )Nr†   F)r–   r›   Ú_is_select_baseró   Úscalar_subqueryÚ_is_from_clauserB   r$   r9   rE   rž   rŠ   Ú_is_lambda_element)rº   rE   r¤   r�   rh   r‰   s         rF   r¢   Ú$_ColumnCoercions._implicit_coercions0  s½   € Ø"ÐÜ�xÐ!4°e×<Ñ<Ø×$Ñ$Ð%5ÀÕIØ×%×%Ø×3Ñ3Ô5Ø×+Ñ+Ó-Ð-Ø×%×%¬*Ø”j×)Ñ)÷+
ñ +
ð ×3Ñ3Ô5Ø×#Ñ#×3Ñ3Ó5Ð5Ø×Ñ×+×+°×0K×0KØˆOà×$Ñ$Ð%5ÀÕIrH   rd   )r×   rØ   rÙ   rÚ   rÛ   ró   r¢   rÝ   re   rH   rF   rð   rð   &  s   † Ø€Iò
÷JrH   rð   c                ó|   • U" S[         R                  " U 5      U(       a  SU< 3OSU(       a  SU-  OSS.-  5      Ue)Nzc%(extra)sTextual SQL expression %(expr)r %(argname)sshould be explicitly declared as text(%(expr)r)úfor argument Ú z%s )r®   r�   Úextra)r   Úellipses_string)rE   r�   Úexc_clsrþ   rÉ   s        rF   Ú_no_text_coercionr  B  sJ   € ñ ð	0ô ×(Ò(¨Ó1ß9@ªGÑ5ÀbÞ&+�U˜U’]°ñ
ñ	
óð ðrH   c                  ó&   • \ rS rSrSrSS.S jrSrg)Ú_NoTextCoercioniT  re   N©r�   c               óº   • [        U[        5      (       a5  [        [        R                  U R
                  5      (       a  [        X5        g U R                  X5        g rd   )rB   rK   rP   r!   r2   rž   r  r›   ©rº   rE   r�   rh   s       rF   r”   Ú!_NoTextCoercion._literal_coercionW  sD   € Ü�gœs×#Ñ#¬
Ü×Ñ ×!1Ñ!1÷)
ñ )
ô ˜gÕ/à×$Ñ$ WÕ6rH   ©r×   rØ   rÙ   rÚ   rÛ   r”   rÝ   re   rH   rF   r  r  T  s   † Ø€Ià48÷ 7ð 7rH   r  c                  ó<   • \ rS rSrSrSrSrSrSS jrSS.S jr	Sr
g)	Ú_CoerceLiteralsi`  re   FNc                ó   • [        X5      $ rd   ©r  ©rº   rE   r�   s      rF   Ú_text_coercionÚ_CoerceLiterals._text_coercionf  ó   € Ü  Ó2Ð2rH   r  c               ó$  • [        U[        5      (       a?  U R                  (       a  US:X  a  [        R                  " SSS9$ U R
                  " X40 UD6$ U R                  (       aL  Uc  [        R                  " 5       $ USL a  [        R                  " 5       $ USL a  [        R                  " 5       $ U R                  (       a=  [        U[        R                  5      (       a  [        R                  " [        U5      SS9$ U R                  X5        g )NÚ*T)Ú
is_literalF)rB   rK   Ú_coerce_starr!   r.   r  Ú_coerce_constsÚNullÚFalse_ÚTrue_Ú_coerce_numericsÚnumbersÚNumberr›   r  s       rF   r”   Ú!_CoerceLiterals._literal_coercioni  sÈ   € Ü�gœs×#Ñ#Ø× ×  W°£^Ü×,Ò,¨S¸TÑBÐBà×*Ò*¨7ÑB¸rÑBÐBà××Ø‰Ü—}’}“Ð&Ø˜EÒ!Ü—’Ó(Ð(Ø˜D’Ü—~’~Ó'Ð'à× × ¤Z°¼'¿.¹.×%JÑ%JÜ×(Ò(¬¨W«À$ÑGÐGà× Ñ  Õ2rH   rd   )r×   rØ   rÙ   rÚ   rÛ   r  r  r  r  r”   rÝ   re   rH   rF   r
  r
  `  s+   † Ø€IØ€NØ€LØÐô3ð 59÷ 3ð 3rH   r
  c                  ó4   • \ rS rSrSr S	SSS.S jjrS rSrg)
ÚLiteralValueImpli~  TNF)Útype_Úliteral_executec               ó|   • [        U5      (       d  U R                  " U4X#S.UD6  [        R                  " S UUSUS9$ )N)r¤   r�   T)r  Úuniquer   )rG   r›   r!   r,   )rº   rE   r¤   r�   r  r   rh   s          rF   r¢   Ú$LiteralValueImpl._implicit_coercions�  sT   € ô ˜8×$Ñ$Ø×$Ò$ØðØ"*ñØ?Aòô ×%Ò%ØØØØØ+ñ
ð 	
rH   c                ó   • U$ rd   re   r¹   s      rF   r”   Ú"LiteralValueImpl._literal_coercion˜  rí   rH   re   rd   )r×   rØ   rÙ   rÚ   r“   r¢   r”   rÝ   re   rH   rF   r  r  ~  s$   † Ø Ðð ð	
ð Øö
õ.rH   r  c                  ób   ^ • \ rS rSrSr  SSSSS.               SU 4S jjjjrSrU =r$ )Ú_SelectIsNotFromiœ  re   NrÆ   c          	     óö   >• U(       d  [        U[        R                  5      (       d  [        U[        R                  5      (       a  SUb  UR                  OU< S3nSnOS n[        TU ]  " U4UUUUUS.UD6   e)NzTo create a FROM clause from a z$ object, use the .subquery() method.Ú89ve)r�   r¤   rÇ   rÈ   rÉ   )rB   r   ÚSelectStatementRolerŸ   Úsuperr›   )	rº   rE   r�   r¤   rÇ   rÈ   rÉ   rh   rŸ   s	           €rF   r›   Ú$_SelectIsNotFrom._raise_for_expectedŸ  s�   ø€ ö Ü˜7¤E×$=Ñ$=×>Ñ>Ü˜(¤E×$=Ñ$=×>Ñ>øð
 *2Ñ)=�8×%Ò%À7ÒJðMð ð
 ‰DàˆDä‰Ò#Øð	
àØØØØñ	
ð ò	
ð 	ˆurH   rÔ   rÕ   ©r×   rØ   rÙ   rÚ   rÛ   r›   rÝ   Ú__classcell__©rŸ   s   @rF   r'  r'  œ  sx   ø† Ø€Ið
 "&Ø"&ð	#ð !%Ø"Ø#'ñ#àð#ð ð#ð  ð	#ð ð#ð ð#ð !ð#ð ð#ð 
÷#÷ #rH   r'  c                  ó@   • \ rS rSrSr S         SS jjrS rSrg)ÚHasCacheKeyImpliÅ  re   Nc                óV   • [        U[        5      (       a  U$ U R                  XU5        g rd   )rB   r   r›   rÄ   s        rF   r¢   Ú#HasCacheKeyImpl._implicit_coercionsÈ  s&   € ô �gœ{×+Ñ+ØˆNà×$Ñ$ W°xÕ@rH   c                ó   • U$ rd   re   r¹   s      rF   r”   Ú!HasCacheKeyImpl._literal_coercionÔ  rí   rH   rd   rÑ   rî   re   rH   rF   r1  r1  Å  óL   † Ø€Ið "&ð	
Aàð
Að ð
Að ð	
Að
 ð
Að 
õ
AõrH   r1  c                  ó@   • \ rS rSrSr S         SS jjrS rSrg)ÚExecutableOptionImpliØ  re   Nc                óV   • [        U[        5      (       a  U$ U R                  XU5        g rd   )rB   r   r›   rÄ   s        rF   r¢   Ú(ExecutableOptionImpl._implicit_coercionsÛ  s'   € ô �gÔ/×0Ñ0ØˆNà×$Ñ$ W°xÕ@rH   c                ó   • U$ rd   re   r¹   s      rF   r”   Ú&ExecutableOptionImpl._literal_coercionç  rí   rH   rd   rÑ   rî   re   rH   rF   r8  r8  Ø  r6  rH   r8  c                  óB   ^ • \ rS rSrSrSSSS.S jrSU 4S jjrSrU =r$ )	ÚExpressionElementImplië  re   NF)r¶   r  Úis_crudc               óø   • Uc0  U(       d)  Ub  UR                   (       d  [        R                  " 5       $  [        R                  " X!USUS9$ ! [        R
                   a  nU R                  XS9   S nAg S nAff = f)NT)r"  Ú_is_crud©rÉ   )Úshould_evaluate_noner!   r  r,   r   r^   r›   )rº   rE   r¶   r  r?  rh   rÉ   s          rF   r”   Ú'ExpressionElementImpl._literal_coercionî  sq   € ð ‰OÞØ‘ e×&@×&@ô
 —=’=“?Ð"ð;Ü×-Ò-Ø 5°Àñð øô ×$Ñ$ó ;Ø×(Ñ(¨Ð(Ö:ûð;ús   µA ÁA9Á A4Á4A9c                ó¸   >• [        U[        R                  5      (       a  SnO$[        U[        R                  5      (       a  SnOS n[
        TU ]  " U4X#US.UD6$ )NzTTo create a column expression from a VALUES clause, use the .scalar_values() method.z`To create a column expression from a FROM clause row as a whole, use the .table_valued() method.©r�   r¤   rÇ   )rB   r$   ÚValuesr   ÚAnonymizedFromClauseRoler+  r›   ©rº   rE   r�   r¤   rh   rÇ   rŸ   s         €rF   r›   Ú)ExpressionElementImpl._raise_for_expected  sm   ø€ ä�gœz×0Ñ0×1Ñ1ð3ñ ô ˜¤×!?Ñ!?×@Ñ@ð>ñ ð
 ˆFä‰wÒ*Øð
Ø$Àñ
ØJLñ
ð 	
rH   rÔ   )	r×   rØ   rÙ   rÚ   rÛ   r”   r›   rÝ   r.  r/  s   @rF   r>  r>  ë  s    ø† Ø€Ið  $¨4¸õ;÷(
õ 
rH   r>  c                  ó6   • \ rS rSrSrSSS.S jrSS.S jrSrg)ÚBinaryElementImpli  re   N)Úbindparam_typer�   c               ó„   •  UR                  X1US9$ ! [        R                   a  nU R                  XS9   S nAg S nAff = f)N)r  rB  )Ú_bind_paramr   r^   r›   )rº   rE   r®   ÚoperatorrM  r�   rh   rÉ   s           rF   r”   Ú#BinaryElementImpl._literal_coercion  sD   € ð	7Ø×#Ñ# H¸^Ð#ÐLÐLøÜ× Ñ ó 	7Ø×$Ñ$ WÐ$Ö6ûð	7ús   ‚ ’?¦:º?)rM  c               ó²   • UR                   R                  (       a;  UR                   R                  (       d   UR                  Ub  UOUR                   5      nU$ rd   )rO   Ú_isnullÚ_with_binary_element_type)rº   r¤   r®   rM  rh   s        rF   r¡   Ú BinaryElementImpl._post_coercion(  s@   € Ø�=‰=× × ¨¯©×):×):Ø×9Ñ9Ø"0Ñ"<‘À$Ç)Á)óˆHð ˆrH   )r×   rØ   rÙ   rÚ   rÛ   r”   r¡   rÝ   re   rH   rF   rL  rL    s%   † Ø€Ið Øõ7ð @D÷ ð rH   rL  c                  óv   • \ rS rSrSr S	         S
S jjrS r\R                  " S5      S 5       r	S r
Srg)ÚInElementImpli0  re   Nc                ó~  • UR                   (       aš  [        U[        R                  5      (       aI  UR                  R
                  (       a.  U R                  U5        U R                  " UR                  40 UD6$ U R                  U5        U R                  " UR                  5       40 UD6$ U R                  XU5        g rd   )
rø   rB   r$   ÚAliasrE   rö   Ú_warn_for_implicit_coercionr¡   Úselectr›   rÄ   s        rF   r¢   Ú!InElementImpl._implicit_coercions3  s”   € ð ×#×#ä˜8¤Z×%5Ñ%5×6Ñ6Ø×$Ñ$×4×4à×0Ñ0°Ô:Ø×*Ò*¨8×+;Ñ+;ÑB¸rÑBÐBà×0Ñ0°Ô:Ø×*Ò*¨8¯?©?Ó+<ÑCÀÑCÐCà×$Ñ$ W°xÕ@rH   c                ó^   • [         R                  " SUR                  R                  -  5        g )Nz_Coercing %s object into a select() for use in IN(); please pass a select() construct explicitly)r   rò   rŸ   r×   )rº   rQ   s     rF   rZ  Ú)InElementImpl._warn_for_implicit_coercionG  s%   € Ü�	Š	ð:à�~‰~×&Ñ&ñ(õ	
rH   zsqlalchemy.sql.elementsc          	     ó  • [         R                  " U5      (       aØ  0 n[        U5      nU Hr  n[        U5      (       a  M  [	        U[         R
                  R                  R                  5      (       d&  [        US5      (       d  U R                  " U40 UD6  Mn  XeU'   Mt     U(       a<  [        R                  " U Vs/ s H  nXe;   a  XV   OUR                  X65      PM     sn6 $ UR                  X1SS9$ U R                  " U40 UD6  g s  snf )NrA   T)Ú	expanding)r   Úis_non_string_iterablerZ   rG   rB   Ú	preloadedÚsql_elementsr/   rD   r›   r!   Ú
ClauseListrO  )rº   rE   r®   rP  rh   Únon_literal_expressionsÚos          rF   r”   ÚInElementImpl._literal_coercionN  s  € ä×&Ò& w×/Ñ/ð ð $ô ˜7“mˆGÛ�Ü" 1—~“~Ü%Øœ4Ÿ>™>×6Ñ6×DÑD÷ñ ä% aÐ)=×>Ñ>Ø×0Ò0°Ñ?¸BÔ?ð 67°Ó2ñ ö 'Ü×*Ò*ñ ")óò ")˜Að  !Ó;ð 4Ò6à!%×!1Ñ!1°(Ó!>ò?ñ ")ñð	ð 	ð ×'Ñ'¨ÀTÐ'ÐJÐJð ×$Ò$ WÑ3°Ó3ùòs   Â<$Dc               ó²  • UR                   (       a  UR                  5       $ [        U[        R                  5      (       a*  [        UR                  5      S:X  a   eUR                  US9$ [        U[        R                  5      (       a  UR                  SS9nSUl
        X1l        U$ [        U[        R                  5      (       a  UR                  5       $ U$ )Nr   )ÚagainstT)Úmaintain_key)rö   r÷   rB   r!   rd  r]   ÚclausesÚ
self_groupr,   Ú_cloner`  Ú	expand_opr$   rG  Úscalar_values)rº   rE   r®   rP  rh   s        rF   r¡   ÚInElementImpl._post_coercionq  s·   € Ø×"×"ð ×*Ñ*Ó,Ð,Ü˜¤×!4Ñ!4×5Ñ5Ü˜7Ÿ?™?Ó+¨qÓ0Ð0Ð0Ø×%Ñ%¨hÐ%Ð7Ð7ä˜¤×!7Ñ!7×8Ñ8Ø—n‘n°$�nÐ7ˆGØ $ˆGÔØ (ÔàˆNÜ˜¤×!2Ñ!2×3Ñ3Ø×(Ñ(Ó*Ð*àˆNrH   rd   rÑ   )r×   rØ   rÙ   rÚ   rÛ   r¢   rZ  r   Úpreload_moduler”   r¡   rÝ   re   rH   rF   rW  rW  0  sr   † Ø€Ið "&ð	AàðAð ðAð ð	Að
 ðAð 
õAò(
ð 
×ÒÐ2Ó3ñ 4ó 4ð 4õDrH   rW  c                  ó0   • \ rS rSrSrSrS rSS.S jrSrg)ÚOnClauseImpli†  re   Tc                ó&   • U R                  U5        g rd   rÃ   r¹   s      rF   r”   ÚOnClauseImpl._literal_coercion‹  s   € Ø× Ñ  Õ)rH   N)r‰   c               óH   • [        U[        R                  5      (       a  U$ U$ rd   )rB   r   ÚJoinTargetRole)rº   r¤   r‰   rh   s       rF   r¡   ÚOnClauseImpl._post_coercionŽ  s#   € ô Ð&¬×(<Ñ(<×=Ñ=Ø#Ð#ØˆrH   )	r×   rØ   rÙ   rÚ   rÛ   r  r”   r¡   rÝ   re   rH   rF   rs  rs  †  s!   † Ø€Ià€Nò*ð <@÷ ð rH   rs  c                  ó&   • \ rS rSrSrSrSS jrSrg)ÚWhereHavingImpli™  re   TNc                ó   • [        X5      $ rd   r  r  s      rF   r  ÚWhereHavingImpl._text_coercionž  r  rH   rd   ©r×   rØ   rÙ   rÚ   rÛ   r  r  rÝ   re   rH   rF   rz  rz  ™  s   † Ø€Ià€N÷3rH   rz  c                  ó&   • \ rS rSrSrSrSS jrSrg)ÚStatementOptionImpli¢  re   TNc                ó.   • [         R                  " U5      $ rd   ©r!   r2   r  s      rF   r  Ú"StatementOptionImpl._text_coercion§  s   € Ü×"Ò" 7Ó+Ð+rH   rd   r}  re   rH   rF   r  r  ¢  s   † Ø€Ià€N÷,rH   r  c                  ó   • \ rS rSrSrSrg)ÚColumnArgumentImpli«  re   N©r×   rØ   rÙ   rÚ   rÛ   rÝ   re   rH   rF   r„  r„  «  ó   † ØƒIrH   r„  c                  ó   • \ rS rSrSrSrg)ÚColumnArgumentOrKeyImpli¯  re   Nr…  re   rH   rF   rˆ  rˆ  ¯  r†  rH   rˆ  c                  ó"   • \ rS rSrSrSS jrSrg)ÚStrAsPlainColumnImpli³  re   Nc                ó.   • [         R                  " U5      $ rd   )r!   r.   r  s      rF   r  Ú#StrAsPlainColumnImpl._text_coercion¶  s   € Ü×$Ò$ WÓ-Ð-rH   rd   )r×   rØ   rÙ   rÚ   rÛ   r  rÝ   re   rH   rF   rŠ  rŠ  ³  s   † Ø€I÷.rH   rŠ  c                  ó&   • \ rS rSrSrSrSS jrSrg)ÚByOfImpliº  re   TNc                ó.   • [         R                  " U5      $ rd   )r!   Ú_textual_label_referencer  s      rF   r  ÚByOfImpl._text_coercion¿  s   € Ü×0Ò0°Ó9Ð9rH   rd   r}  re   rH   rF   rŽ  rŽ  º  s   † Ø€Ià€N÷:rH   rŽ  c                  ó   • \ rS rSrSrS rSrg)ÚOrderByImpliÃ  re   c                ó€   • [        XR                  5      (       a#  UR                  b  [        R                  " U5      $ U$ rd   )rB   rž   Ú_order_by_label_elementr!   Ú_label_reference)rº   r¤   rh   s      rF   r¡   ÚOrderByImpl._post_coercionÆ  s5   € ä�x×!1Ñ!1×2Ñ2Ø×0Ñ0Ñ<ä×,Ò,¨XÓ6Ð6àˆOrH   Nrã   re   rH   rF   r“  r“  Ã  s   † Ø€IõrH   r“  c                  ó:   • \ rS rSrSr S         SS jjrSrg)ÚGroupByImpliÐ  re   Nc                ó`   • [        U5      (       a  [        R                  " UR                  6 $ U$ rd   )r   r!   rd  ÚcrÄ   s        rF   r¢   ÚGroupByImpl._implicit_coercionsÓ  s)   € ô ˜(×#Ñ#Ü×&Ò&¨¯
©
Ð3Ð3àˆOrH   rd   rÑ   ©r×   rØ   rÙ   rÚ   rÛ   r¢   rÝ   re   rH   rF   r™  r™  Ð  sF   † Ø€Ið "&ð	
àð
ð ð
ð ð	
ð
 ð
ð 
÷
ð 
rH   r™  c                  ó&   • \ rS rSrSrSS.S jrSrg)ÚDMLColumnImplià  re   Frk   c               ó,   • U(       a  UR                   $ U$ rd   )Úkey)rº   rE   rl   rh   s       rF   r¡   ÚDMLColumnImpl._post_coercionã  s   € ÞØ—;‘;ÐàˆNrH   Nrã   re   rH   rF   rŸ  rŸ  à  s   † Ø€Ià05÷ ð rH   rŸ  c                  ó&   • \ rS rSrSrSS.S jrSrg)ÚConstExprImpliê  re   Nr  c               ó¾   • Uc  [         R                  " 5       $ USL a  [         R                  " 5       $ USL a  [         R                  " 5       $ U R	                  X5        g )NFT)r!   r  r  r  r›   r  s       rF   r”   ÚConstExprImpl._literal_coercioní  sJ   € Ø‰?Ü—=’=“?Ð"Ø˜ÒÜ—?’?Ó$Ð$Ø˜Š_Ü—>’>Ó#Ð#à×$Ñ$ WÕ6rH   r  re   rH   rF   r¤  r¤  ê  s   † Ø€Ià48÷ 7ð 7rH   r¤  c                  ó@   • \ rS rSrSr S         SS jjrS rSrg)ÚTruncatedLabelImpliø  re   Nc                óV   • [        U[        5      (       a  U$ U R                  XU5        g rd   ré   rÄ   s        rF   r¢   Ú&TruncatedLabelImpl._implicit_coercionsû  s&   € ô �gœs×#Ñ#ØˆOà×$Ñ$ W°xÕ@rH   c                óp   • [        U[        R                  5      (       a  U$ [        R                  " U5      $ )z˜coerce the given value to :class:`._truncated_label`.

Existing :class:`._truncated_label` and
:class:`._anonymous_label` objects are passed
unchanged.
)rB   r!   Ú_truncated_labelr¹   s      rF   r”   Ú$TruncatedLabelImpl._literal_coercion  s-   € ô �gœx×8Ñ8×9Ñ9ØˆNä×,Ò,¨WÓ5Ð5rH   rd   rÑ   rî   re   rH   rF   r¨  r¨  ø  sL   † Ø€Ið "&ð	
Aàð
Að ð
Að ð	
Að
 ð
Að 
õ
Aõ6rH   r¨  c                  ó&   • \ rS rSrSrSrSS jrSrg)ÚDDLExpressionImpli  re   TNc                ó.   • [         R                  " U5      $ rd   r�  r  s      rF   r  Ú DDLExpressionImpl._text_coercion  s   € ô
 ×"Ò" 7Ó+Ð+rH   rd   r}  re   rH   rF   r¯  r¯    s   † Ø€Ià€N÷,rH   r¯  c                  ó   • \ rS rSrSrSrg)ÚDDLConstraintColumnImpli"  re   Nr…  re   rH   rF   r³  r³  "  r†  rH   r³  c                  ó   • \ rS rSrSrSrg)ÚDDLReferredColumnImpli&  re   Nr…  re   rH   rF   rµ  rµ  &  r†  rH   rµ  c                  ó@   • \ rS rSrSr S         SS jjrS rSrg)ÚLimitOffsetImpli*  re   Nc                ó0   • Uc  g U R                  XU5        g rd   rÃ   rÄ   s        rF   r¢   Ú#LimitOffsetImpl._implicit_coercions-  s   € ð ÑØà×$Ñ$ W°xÕ@rH   c               ób   • Uc  g [         R                  " U5      n[        R                  " X%USS9$ )NT)r  r"  )r   Úasintr$   Ú_OffsetLimitParam)rº   rE   r¶   r  rh   Úvalues         rF   r”   Ú!LimitOffsetImpl._literal_coercion9  s4   € ð ‰?Øä—J’J˜wÓ'ˆEÜ×/Ò/Ø 5°ñð rH   rd   rÑ   rî   re   rH   rF   r·  r·  *  sL   † Ø€Ið "&ð	
Aàð
Að ð
Að ð	
Að
 ð
Að 
õ
Aõ	rH   r·  c                  óH   ^ • \ rS rSrSr S         SU 4S jjjrSrU =r$ )ÚLabeledColumnExprImpliE  re   c                ó  >• [        U[        R                  5      (       a  UR                  S 5      $ [        TU ]  " X4SU0UD6n[        U[        R                  5      (       a  UR                  S 5      $ U R                  XU5        g ©Nr�   )rB   r   ÚExpressionElementRoleÚlabelr+  r¢   r›   )rº   rE   r¤   r�   rh   ÚnewrŸ   s         €rF   r¢   Ú)LabeledColumnExprImpl._implicit_coercionsH  s|   ø€ ô �h¤× ;Ñ ;×<Ñ<Ø—>‘> $Ó'Ð'ä‘'Ò-ØñØ+2ðØ68ñˆCô ˜#œu×:Ñ:×;Ñ;Ø—y‘y “Ð&à×(Ñ(¨¸8ÕDrH   rd   rÑ   )r×   rØ   rÙ   rÚ   rÛ   r¢   rÝ   r.  r/  s   @rF   rÀ  rÀ  E  sN   ø† Ø€Ið "&ð	EàðEð ðEð ð	Eð
 ðEð 
÷Eö ErH   rÀ  c                  óŠ   ^ • \ rS rSrSrSrSrSr\R                  " S\R                  5      r S	SS.U 4S jjjrS
S jrSrU =r$ )ÚColumnsClauseImpli[  re   Tz^\w\S*$N)rÇ   c               óœ   >• U(       d1  [        U[        5      (       a  SSR                  S U 5       5       S3n[        TU ]  " U4X#US.UD6$ )NzDid you mean to say select(z, c              3  ó8   #   • U  H  n[        U5      v •  M     g 7frd   )rÍ   )Ú.0Úes     rF   Ú	<genexpr>Ú8ColumnsClauseImpl._raise_for_expected.<locals>.<genexpr>j  s   é € Ð6ªg¨œT !ŸW˜Wªgùs   ‚z)?rF  )rB   rZ   Újoinr+  r›   )rº   rE   r�   r¤   rÇ   rh   rŸ   s         €rF   r›   Ú%ColumnsClauseImpl._raise_for_expectedd  sa   ø€ ö œ* W¬d×3Ñ3à-Ø—9‘9Ñ6©gÓ6Ó6Ð7°rð;ð ô
 ‰wÒ*Øð
Ø$Àñ
ØJLñ
ð 	
rH   c                óæ   • [        U5      nU R                  R                  U5      (       + n[        R                  " S[
        R                  " U5      U(       a  SU< 3OSU(       a  SOSS.-  5      e)NzŸTextual column expression %(column)r %(argname)sshould be explicitly declared with text(%(column)r), or use %(literal_column)s(%(column)r) for more specificityrü   rý   Úliteral_columnrª   )rª   r�   rÒ  )rK   Ú_guess_straight_columnÚmatchr   r^   r   rÿ   )rº   rE   r�   Úguess_is_literals       rF   r  Ú ColumnsClauseImpl._text_coercionq  si   € Ü�g“,ˆà#×:Ñ:×@Ñ@ÀÓIÔIÐÜ×Òð#ô
 ×.Ò.¨wÓ7ß=D²Ñ9È"æ(8Ñ$¸hñ	ñ	
ó
ð 	
rH   rÔ   rd   )r×   rØ   rÙ   rÚ   rÛ   r  r  r  ÚreÚcompileÚIrÓ  r›   r  rÝ   r.  r/  s   @rF   rÈ  rÈ  [  sN   ø† Ø€Ià€NØÐØ€LàŸZšZ¨
°B·D±DÓ9Ðð /3ð
Ø>B÷
ñ 
÷
ò 
rH   rÈ  c                  ó   • \ rS rSrSrSrg)ÚReturnsRowsImpli„  re   Nr…  re   rH   rF   rÛ  rÛ  „  r†  rH   rÛ  c                  óV   ^ • \ rS rSrSrSS.S jr S         SU 4S jjjrSrU =r$ )	ÚStatementImpliˆ  re   Nr  c               ó¬   • XLa$  [        U[        5      (       d   UR                    U$ U$ ! [         a    [        R
                  " SU-  S5         U$ f = f)Na  Object %r should not be used directly in a SQL statement context, such as passing to methods such as session.execute().  This usage will be disallowed in a future release.  Please use Core select() / update() / delete() etc. with Session.execute() and other statement execution methods.ú1.4)rB   rK   Ú_execute_on_connectionrš   r   Úwarn_deprecated)rº   r¤   r‰   r�   rh   s        rF   r¡   ÚStatementImpl._post_coercion‹  sn   € ð Ò+´JØœc÷5
ñ 5
ð
Ø ×7Ò7ð ˆˆxˆøô "ó 
Ü×$Ò$ðð "2ñ2ð õ	ð ˆð
ús   ›+ «$AÁAc                óP   >• UR                   (       a  U$ [        TU ]  " X4SU0UD6$ rÂ  )rù   r+  r¢   )rº   rE   r¤   r�   rh   rŸ   s        €rF   r¢   Ú!StatementImpl._implicit_coercions£  s8   ø€ ð ×&×&ØˆOä‘7Ò.ØñØ+2ðØ68ñð rH   rd   rÑ   )	r×   rØ   rÙ   rÚ   rÛ   r¡   r¢   rÝ   r.  r/  s   @rF   rÝ  rÝ  ˆ  sQ   ø† Ø€Ið 6:õð8 "&ð	àðð ðð ð	ð
 ðð 
÷ö rH   rÝ  c                  ó:   • \ rS rSrSr S         SS jjrSrg)ÚSelectStatementImpli²  re   Nc                ój   • UR                   (       a  UR                  5       $ U R                  XU5        g rd   )Ú_is_text_clauseÚcolumnsr›   rÄ   s        rF   r¢   Ú'SelectStatementImpl._implicit_coercionsµ  s,   € ð ×#×#Ø×#Ñ#Ó%Ð%à×$Ñ$ W°xÕ@rH   rd   rÑ   r�  re   rH   rF   ræ  ræ  ²  sM   † Ø€Ið "&ð	
Aàð
Að ð
Að ð	
Að
 ð
Að 
÷
Að 
ArH   ræ  c                  ó   • \ rS rSrSrSrg)Ú
HasCTEImpliÂ  re   Nr…  re   rH   rF   rì  rì  Â  r†  rH   rì  c                  ó   • \ rS rSrSrSrg)Ú	IsCTEImpliÆ  re   Nr…  re   rH   rF   rî  rî  Æ  r†  rH   rî  c                  óX   • \ rS rSrSrSrSS.S jr S
SS.           SS	 jjjrSrg)ÚJoinTargetImpliÊ  re   TNr  c               ó&   • U R                  X5        g rd   rÃ   r  s       rF   r”   Ú JoinTargetImpl._literal_coercionÏ  s   € Ø× Ñ  Õ2rH   F)Úlegacyc               óÈ   • [        U[        R                  5      (       a  U$ U(       a(  UR                  (       a  [        R
                  " SSS9  U$ U R                  XU5        g ©NzÀImplicit coercion of SELECT and textual SELECT constructs into FROM clauses is deprecated; please call .subquery() on any Core select or ORM Query object in order to produce a subquery object.rß  )Úversion)rB   r   rw  rö   r   rá  r›   )rº   rE   r¤   r�   ró  rh   s         rF   r¢   Ú"JoinTargetImpl._implicit_coercionsÒ  sX   € ô �gœu×3Ñ3×4Ñ4ð ˆNÞ˜×0×0Ü× Ò ð6ð òð ˆOà×$Ñ$ W°xÕ@rH   rd   )rE   r   r¤   r   r�   rÒ   ró  Úboolrh   r   rÓ   r   )	r×   rØ   rÙ   rÚ   rÛ   r•   r”   r¢   rÝ   re   rH   rF   rð  rð  Ê  sq   † Ø€Ià+/Ð(à48õ 3ð "&ð	Að ñAàðAð ðAð ð	Að ðAð ðAð 
÷Añ ArH   rð  c                  óZ   • \ rS rSrSr S
SSS.             SS jjjrSS.S	 jrSrg)ÚFromClauseImpliñ  re   NFT)r{   Úallow_selectc               óð   • UR                   (       a@  U(       a  UR                  5       $ U(       a!  [        R                  " SSS9  UR                  $ g UR
                  (       a  U$ U R                  XU5        g rõ  )rö   Úsubqueryr   rá  Ú_implicit_subqueryrè  r›   )rº   rE   r¤   r�   r{   rû  rh   s          rF   r¢   Ú"FromClauseImpl._implicit_coercionsô  sm   € ð ×#×#Þ Ø×(Ñ(Ó*Ð*ÞÜ×$Ò$ð:ð "òð  ×2Ñ2Ð2ð ð ×%×%ØˆOà×$Ñ$ W°xÕ@rH   )Ú
deannotatec               ó4   • U(       a  UR                  5       $ U$ rd   )Ú_deannotate)rº   rE   r   rh   s       rF   r¡   ÚFromClauseImpl._post_coercion  s   € ÞØ×&Ñ&Ó(Ð(àˆNrH   rd   )rE   r   r¤   r   r�   rÒ   r{   rø  rû  rø  rh   r   rÓ   r   )r×   rØ   rÙ   rÚ   rÛ   r¢   r¡   rÝ   re   rH   rF   rú  rú  ñ  sz   † Ø€Ið "&ð	Að #(Ø!ñAàðAð ðAð ð	Að  ðAð ðAð ðAð 
öAð6 5:÷ ð rH   rú  c                  óF   • \ rS rSrSr SSS.           SS jjjrSrg)	ÚStrictFromClauseImpli  re   NF)rû  c               óš   • UR                   (       a(  U(       a!  [        R                  " SSS9  UR                  $ U R	                  XU5        g rõ  )rö   r   rá  rþ  r›   )rº   rE   r¤   r�   rû  rh   s         rF   r¢   Ú(StrictFromClauseImpl._implicit_coercions  sE   € ð ×#×#®Ü× Ò ð#ð òð ×.Ñ.Ð.à×$Ñ$ W°xÕ@rH   rd   )rE   r   r¤   r   r�   rÒ   rû  rø  rh   r   rÓ   r   r�  re   rH   rF   r  r    sc   † Ø€Ið "&ð	Að #ñAàðAð ðAð ð	Að ðAð ðAð 
÷Añ ArH   r  c                  ó(   • \ rS rSrSrSSS.S jrSrg)ÚAnonymizedFromClauseImpli/  re   FN)Úflatr¶   c               ó*   • Ub   eUR                  US9$ )N)r
  )Ú_anonymous_fromclause)rº   rE   r
  r¶   rh   s        rF   r¡   Ú'AnonymizedFromClauseImpl._post_coercion2  s    € Ø‰|Ðˆ|à×,Ñ,°$Ð,Ð7Ð7rH   rã   re   rH   rF   r	  r	  /  s   † Ø€Ià.3¸$÷ 8ð 8rH   r	  c                  ó   • \ rS rSrSrS rSrg)ÚDMLTableImpli8  re   c                óD   • SUR                   ;   a  UR                   S   $ U$ )NÚ	dml_table)Ú_annotationsr¹   s      rF   r¡   ÚDMLTableImpl._post_coercion;  s&   € Ø˜'×.Ñ.Ó.Ø×'Ñ'¨Ñ4Ð4àˆNrH   Nrã   re   rH   rF   r  r  8  s   † Ø€IõrH   r  c                  ó:   • \ rS rSrSr S         SS jjrSrg)ÚDMLSelectImpliB  re   Nc                óö   • UR                   (       aV  [        U[        R                  5      (       a'  UR                  R
                  (       a  UR                  $ UR                  5       $ U R                  XU5        g rd   )rø   rB   r$   rY  rE   rö   r[  r›   rÄ   s        rF   r¢   Ú!DMLSelectImpl._implicit_coercionsE  sX   € ð ×#×#ä˜8¤Z×%5Ñ%5×6Ñ6Ø×$Ñ$×4×4à×'Ñ'Ð'à—‘Ó(Ð(à×$Ñ$ W°xÕ@rH   rd   rÑ   r�  re   rH   rF   r  r  B  sM   † Ø€Ið "&ð	AàðAð ðAð ð	Að
 ðAð 
÷Að ArH   r  c                  ó0   ^ • \ rS rSrSrSU 4S jjrSrU =r$ )ÚCompoundElementImpliX  re   c                óœ   >• [        U[        R                  5      (       a  UR                  (       a  SnOSnOS n[        TU ]  " U4X#US.UD6$ )NzFUse the plain select() object without calling .subquery() or .alias().z9To SELECT from any FROM clause, use the .select() method.rF  )rB   r   ÚFromClauseRoleÚ_is_subqueryr+  r›   rI  s         €rF   r›   Ú'CompoundElementImpl._raise_for_expected[  sb   ø€ Ü�gœu×3Ñ3×4Ñ4Ø×#×#ð7ñ ð Pñ ð ˆFÜ‰wÒ*Øð
Ø$Àñ
ØJLñ
ð 	
rH   rÔ   r-  r/  s   @rF   r  r  X  s   ø† Ø€I÷
õ 
rH   r  ÚRoleÚImpl)rE   r   rÓ   rø  )rT   rK   rU   rK   rV   rK   rÓ   zCallable[[_F], _F])r_   rK   r`   rK   ra   z+Union[Sequence[_T], Sequence[Sequence[_T]]]rÓ   rY   )rg   zType[roles.TruncatedLabelRole]rE   r   rh   r   rÓ   rK   )
rg   úType[roles.DMLColumnRole]rE   r   rl   úLiteral[True]rh   r   rÓ   rK   )rg   zType[roles.LiteralValueRole]rE   r   rh   r   rÓ   zBindParameter[Any])rg   z!Type[roles.DDLReferredColumnRole]rE   r   rh   r   rÓ   úUnion[Column[Any], str])rg   ú#Type[roles.DDLConstraintColumnRole]rE   r   rh   r   rÓ   r"  )rg   zType[roles.StatementOptionRole]rE   r   rh   r   rÓ   z%Union[ColumnElement[Any], TextClause])rg   z&Type[roles.LabeledColumnExprRole[Any]]rE   z=Union[_ColumnExpressionArgument[_T], _OnlyColumnArgument[_T]]rh   r   rÓ   zNamedColumn[_T])rg   zgUnion[Type[roles.ExpressionElementRole[Any]], Type[roles.LimitOffsetRole], Type[roles.WhereHavingRole]]rE   z_ColumnExpressionArgument[_T]rh   r   rÓ   zColumnElement[_T])rg   z¡Union[Type[roles.ExpressionElementRole[Any]], Type[roles.LimitOffsetRole], Type[roles.WhereHavingRole], Type[roles.OnClauseRole], Type[roles.ColumnArgumentRole]]rE   r   rh   r   rÓ   zColumnElement[Any])rg   zType[roles.DMLTableRole]rE   r(   rh   r   rÓ   r+   )rg   zType[roles.HasCTERole]rE   r7   rh   r   rÓ   r7   )rg   zType[roles.SelectStatementRole]rE   r8   rh   r   rÓ   r8   )rg   úType[roles.FromClauseRole]rE   r)   rh   r   rÓ   r6   )
rg   r$  rE   r8   r{   r!  rh   r   rÓ   r9   )rg   zType[roles.ColumnsClauseRole]rE   z_ColumnsClauseArgument[Any]rh   r   rÓ   r4   )rg   zType[roles.JoinTargetRole]rE   r5   rh   r   rÓ   r5   )rg   ú	Type[_SR]rE   r   rh   r   rÓ   r   )rg   r%  rE   r   r€   zOptional[ClauseElement]r�   rÒ   r‚   rø  rƒ   rø  rh   r   rÓ   r   )rg   r   rE   r   rh   r   rÓ   rK   )rg   r#  r­   zIterable[_DDLColumnArgument]rÓ   zwIterator[Tuple[Union[str, Column[Any]], Optional[ColumnClause[Any]], Optional[str], Optional[Union[Column[Any], str]]]])rE   r   r�   rÒ   r   zType[exc.SQLAlchemyError]rþ   rÒ   rÉ   rÖ   rÓ   r   )�Ú
__future__r   Úcollections.abcÚabcrJ   r  r×  r�   r   r   r   r   r   r	   r
   r   r   r   r   r   r   r   r   r   rý   r   r   Ú_typingr   Úbaser   r   Ú	cache_keyr   r   r   r   r   Úutil.typingr    r!   r"   r#   r$   r%   r&   r'   r(   r)   r*   Údmlr+   r,   r-   r.   r/   r0   r1   r2   r3   r4   r5   r6   r7   r8   r9   r:   ÚSQLRoler;   r=   Ú
StringRoler>   r?   rG   rL   rW   rb   ri   r¨   r³   rµ   rß   rå   rç   rð   r^   r  r  r
  r  r'  r1  r8  r>  rL  rW  rs  rz  r  r„  rˆ  rŠ  ÚByOfRolerŽ  r“  r™  rŸ  r¤  r¨  r¯  r³  rµ  r·  rÀ  rÈ  rÛ  rÝ  ræ  rì  rî  rð  rú  r  r	  r  r  r  rŽ   Údirr¶   r–   ÚclsÚendswithÚreplaceÚglobalsr£   rÃ  Úee_implÚintrø  rK   ÚfloatÚpy_typere   rH   rF   Ú<module>r:     sL	  ðõ #å )Û Û 	Û Ý Ý Ý Ý Ý Ý Ý Ý Ý Ý Ý Ý Ý Ý  Ý Ý å Ý Ý #Ý "Ý Ý "Ý Ý Ý Ý Ý !à	××åÝÝÝÝ2Ý/Ý+Ý*Ý,Ý,Ý%Ý'Ý'Ý&Ý'Ý%Ý+Ý$ÝÝ1Ý/Ý&Ý"Ý&Ý$Ý/áˆe˜5Ÿ=™=Ñ)€ÙˆT˜ # s (Ñ+Ñ,€Ù�~¨U×-=Ñ-=Ñ>€ÙˆT˜Ñ€ô	5ò#ðLØðØ!ðØ.1ðàôð &Øð&àð&ð 6ð&ð ô	&ð$ 
ðØ
(ðàðð ðð 	ó	ó 
ðð 
ð
  ñ	Ø
#ðàðð ð	ð
 ðð 	ôó 
ðð 
ðØ
&ðàðð ðð ó	ó 
ðð 
ð"Ø
+ð"àð"ð ð"ð ó	"ó 
ð"ð 
ð"Ø
-ð"àð"ð ð"ð ó	"ó 
ð"ð 
ð0Ø
)ð0àð0ð ð0ð +ó	0ó 
ð0ð 
ðØ
0ðàJðð ðð ó	ó 
ðð 
ðððð +ðð ðð óó 
ðð 
ð
ðð
ð ð
ð ð
ð ó
ó 
ð
ð 
ðØ
"ðàðð ðð ó	ó 
ðð 
ðØ
 ðàðð ðð ó	ó 
ðð 
ðØ
)ðàðð ðð ó	ó 
ðð 
ðØ
$ðà ðð ðð ó	ó 
ðð 
ð
 (+ñ	Ø
$ðàðð %ð	ð
 ðð ôó 
ðð 
ð Ø
'ð à(ð ð ð ð ó	 ó 
ð ð 
ðØ
$ðà ðð ðð ó	ó 
ðð 
ðØ
ðàðð ðð 	ó	ó 
ðð 6:Ø!ØØ$ñq
Ø
ðq
àðq
ð 3ð	q
ð
 ðq
ð ðq
ð ðq
ð ðq
ð 	õq
ðh4Ø
#ð4Ø.1ð4Ø9<ð4àô4ð5Ø
-ð5à-ð5ðô5÷<49ñ 49÷n*ñ *÷!ñ !ô
˜ô 
ôJ�xô Jð< "Ø),×):Ñ):ØØ#ðØðàðð 'ðð ð	ð
 
ðð õô$	7�hô 	7ô3�hô 3ô<�xô ô<&�xô &ôR�hô ô&˜8ô ô&(
Ð,¨hô (
ôVÐ-¨xô ô4S�Hô SôlÐ# Xô ô&3�oÐ'7¸ô 3ô,˜/¨8ô ,ô˜¨(ô ôÐ/°ô ô.˜?¨Hô .ô:ˆÐ 0°(¸E¿N¹Nô :ô
�(˜Hô 
ô�(˜Hô ô Ð% xô ô7�Hô 7ô6˜ hô 6ô:
,˜ _°hô 
,ô˜kÐ+<¸hô ôÐ3ô ô�hô ô6EÐ1ô Eô,&
Ð(¨/¸8ô &
ôR�hô ô'�O Xô 'ôTA˜/¨8ô Aô �ô ô�ô ô$A�Xô $AôN"Ð% ¸ô "ôJA˜>ô Aô28Ð3ô 8ôÐ# _°hô ôA�O Xô Aô,
˜/¨8ô 
ð* €ñ �ŽJ€DÙ
�%˜Ó
€CØ‡}‚}�V×ÓØ�|Š|˜F FÓ+ˆØ‘7“9ÕÙ“9˜T’? 3Ó'ˆDØ $ˆL˜Óñ ö Ø˜5×6Ò6Ñ7€Gà˜˜s EÓ*ˆØ=Dˆ�U×0Ò0°Ñ9Ó:ò +ð rH   